- Access LoggingAccess Logging allows monitoring of data access requests in the system and log granted and/or denied requests.
- This is how you find out who is logging into Teradata and who has tried and failed.
- This is how you track who is trying to access certain tables and information and who has been denied.
- When you track someone or everyone, the Access Logs are written to before the query runs so this does slow down queries.
- The DBA is first given permission to utilize Access Logging, and then they have to perform a BEGIN LOGGING statement for any action to be taken and tracking logs written to.
- When you track someone or everyone, the Access Logs are written to before the query runs so this does slow down queries.
DBC.AccLogRule
DBC.AccLogRuleTbl
DBC.AccLogRules[V]
DBC.AccLogTbl
DBC.AccessLog[V]
written to the DBC.AccLogTbl each time the rule comes into play. Views are setup to see the rules and the entries. These are listed above.