Example: Using AccessLogV - Teradata Vantage

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