Archives of the TeradataForum

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

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

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>>