Archives of the TeradataForum

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

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

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.

Thanks,

Bob Diehl
Travelcoity.com

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