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

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.