15.10 - DeleteAccessLogV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Security

DBC

 

View Column

Data Type

Format

Source Table.Column

LogDate

DATE

NOT NULL

YY/MM/DD (explicit)

AccLogTbl.TheDate

LogTime

TIME

NOT NULL

99:99:99 (explicit)

AccLogTbl.TheTime

The access log contains entries according to the application of the access logging rules (see “AccessLogV” on page 40 and “AccLogRulesV” on page 44).

The view also may be used to display information about records that are eligible for deletion before the delete operation is performed.

The following statement deletes entries logged more than 30 days before the current calendar date:

==> DELETE FROM DBC.DeleteAccessLogV ALL;

Result:

    DELETE COMPLETED.  79 RECORDS DELETED.