Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 07 Apr 2004 @ 12:54:36 GMT


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


Subj:   Update Audit Trails
 
From:   Simon Bloomer

Hi Teradata gurus

I wonder if someone can give me some advice on something which falls under the gambit of query logging, but I'm not clear on the best way to implement it. We have a requirement for auditing all changes (updates) within a table. In other words, we want to know what the data was before the change, who changed it, and what was the actual change made? I was thinking that query logging on a user and object basis would work, but, in the same way as using triggers to do it, we don't know what the "before" image would then have looked like. We only have this requirement for a couple of tables.

Any ideas would be most helpful...


Thanks

Simon



     
  <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