Archives of the TeradataForum
Message Posted: Wed, 01 Dec 2004 @ 17:53:30 GMT
<-- Anonymously Posted: Wednesday, December 01, 2004 12:30 -->
Hi, we have enabled dbql and turned off access logging. What I need now (RTFM isn't helping) is to find a query I can run against the dbql tables that will allow me to look at what sql a user was running in the past.
Against access log I could write something like:
select * from dbc.accesslog where username = 'zzzzz' and tvmname = 'xxxxx' and requesttext like '%yyy%' and logdate > date-7;
(this is just an off the top of my head example....)
what sql would give me something similar out of dbql?
Thanks in Advance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|