TERADATA Access logging

  • 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.