Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 15 Mar 2005 @ 22:58:53 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: History of database access
From:   Diehl, Robert

The answer depends on what you have turned on and for whom.

1) Turn on access logging. This will log every object accessed.

You can turn on by id or for everybody. Watch the table growth.

2) Turn on Query Logging. You can very the amount of data collected.

It is better than Access logging most respects. It can be turned on by userid or account string. Don't forget to clean up history or move to another table.

3) System wide OBJECT USAGE COUNT. See DATABASE ADMINISTRATION manual Chapter 14. This logs the last usage date and total uses in the dictionary tables for all objects. This does not tell you who accessed it, just that it was accessed.

There is a cost to all of the above Query Logging is much more efficient than access logging. It is what I would recommend. Hopefully you already have it activated. Don't forget to cleanup the tables or move them to a historical database.


Bob Diehl

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023