16.10 - About Access Log Maintenance - Teradata Database

Teradata Database Security Administration

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Administration
Security
Publication ID
B035-1100-161K
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 suggests 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 Database Administration.