Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Username and last modified information for a particular table
From:   Michael Larkins

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016