Archives of the TeradataForum
Message Posted: Wed, 03 Jan 2007 @ 14:12:02 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|