Re: Audit Trails

Already figured it would require triggers and looked at that site already. Thanks though. The site didn't really help clear up things like updating a single column in a row, or if someone submits all fields in an update, and only one column of data has changed, how to deal with things like that.

JR

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3d47efa7$0$8509$ed9e5944_at_reading.news.pipex.net>...
> "John" <jriker1_at_yahoo.com> 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.
>
> You'll need I think to look at triggers to implement this.
>
> Database auditing is covered at
> http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/
> a76965/c27audit.htm
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
Received on Wed Jul 31 2002 - 15:52:37 CDT