Archives of the TeradataForum

Message Posted: Wed, 03 Jan 2007 @ 14:12:02 GMT

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

You could create an audit table and then create a trigger for each maintenance activity you want to track. The trigger could then insert into the audit table data like the userid (USER), date, time (or timestamp) and even the old and new data for an update. This way you can have a complete audit of every insert, update and delete. There are a lot of the tools are in Teradata, all you have to do is use them.

You could also experiment with putting the userid column into the table. However, this might only work for inserts. To know for sure you will need to experiment with an update. However, it loses all info on a delete.

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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