Audit Trail - Can it include changed values?

Hi,

I'm setting up a system where the customer wants an audit record of chnages made to the tables, including the user, time, what field was changed, and the before and after values.

I am able to do this with triggers/procedures, and an audit trail table. With the number of tables and fields involved, it will take me a few years to get this in place!

Is the Oracle Audit package able to track the before and after values of modified rows? It looks like it will only track who,when,what table, and what kind of action was taken, not the actual changes made.

Thanks for any help!

Gene Plagge
Programmer/Analyst
Systems Integrated
San Diego, Ca.
gplagge_at_siwest.cts.com
(619) 277-0700 Received on Thu Jun 13 1996 - 00:00:00 CEST