Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Audit Trails
I don't think auditting will give the details that you need.
Just so you are not reinventing the wheele, you might want to take a
look at LogMiner and Change Data Capture. Of course ORACLE knows
everything about everything within the database. Everything is
recorded in the redo logs. It is just a matter of digging up info. you
need from these logs.
jriker1_at_yahoo.com (John) wrote in message news:<e6bb5a8d.0207310525.21c8cb4d_at_posting.google.com>...
> I have a requirement to develop an application with an Oracle back end
> database, that can keep track of all changes made to a record. So say
> I do an insert, and then change one value in that record, say the
> Salary column. I need to have a log that so and so changed the salary
> in this record on such a date. Does setting audit_trail to true do
> that? If not, what does the audit_trail flag do, and are there any
> pointers to implementing something like this? Thanks.
>
> JR
Received on Wed Jul 31 2002 - 19:39:11 CDT