17.10 - Example: Using AccessLogV - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

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

The following SELECT retrieves the name of the submitting user from the AccessLogV view, the type of request, and the request text of each request that caused a privilege check to be logged on a specific date. The response shows that one request caused a privilege check to be logged on that date. (The statement text column has been truncated in the results.)

SELECT LogDate, UserName, AccessType, StatementText
FROM DBC.AccessLogV WHERE LogDate = 890510;

Result:

LogDate   UserName  AccessType  StatementText
--------  --------  ----------  ------------------------------
89/05/10  Jones     CT          CREATE TABLE Jones.EmpDup (Em