Archives of the TeradataForum
Message Posted: Wed, 07 Apr 2004 @ 12:54:36 GMT
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...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|