How to find list of users by table name

General

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

2 REPLIES
Enthusiast

Re: How to find list of users by table name

You can use dbc.acceslog

Enthusiast

Re: How to find list of users by table name

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)