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

Teradata Vantage™ - Advanced SQL Engine Security Administration

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
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.