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