17.00 - Example: Using AccessLogV - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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