Re: Audit Trails

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 31 Jul 2002 15:09:42 +0100
Message-ID: <3d47efa7$0$8509$ed9e5944@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 - 09:09:42 CDT