Re: Audit Trail - Can it include changed values?

In <4ppnq7$n51_at_news3.cts.com>, saii_at_cts.com (Gene_Plagge) writes:
>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

I just went through exactly the same type of exercise. You are right about the Oracle audit package; it does NOT track old and new values.

I know, not what you wanted to hear.

M.Landa Received on Fri Jun 14 1996 - 00:00:00 CEST