Access Log Maintenance | Teradata Vantage - 17.10 - About Access Log Maintenance - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)

The DBC.AccessLogTbl collects and retains data while access logging is enabled. To save database space and shorten searches of the log, you should periodically purge the DBC.AccessLogTbl of old data. The purge interval varies based on the type and amount of logging that you enable.

Teradata recommends that you transfer log data into a separate log history table or archive it to tape, so that log history remains available in the event of a subsequent security investigations.

For information about managing accumulated log data, see Teradata Vantage™ - Data Dictionary, B035-1092.