All Forums General
msheik4637 3 posts Joined 04/10
10 Nov 2011
How to find list of users by table name

Hi,

 

i would like to know which DBQL tables can be used to find the list of users who are accessing a particular table from the last 3 months

Please let me know if any one has some ideas.

Also, please let me know if there is any reference guide for DBQL tables explaining each table and their use

Thanks

 

 

 

Ashok.Pentapati 16 posts Joined 06/09
11 Nov 2011

You can use dbc.acceslog

robpaller 159 posts Joined 05/09
15 Nov 2011

Access Logging will only capture that information if you have enabled access logging.

As for DBQL if you are retaining the object level data you can use the QryLog and QryLogObjects views (or their equivalent historical tables/views) to find the information you are seeking.

Chapter 14 of the Database Administration manual should provide some more detail on the query logging mechanism in Teradata. (http://www.info.teradata.com/edownload.cfm?itemid=102320018)

You must sign in to leave a comment.