16.20 - Example: Using AccessLogV - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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