Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: auditing....
Mischa Pijnenburg <mischa.pijnenburg_at_prive.ordina.nl> wrote:
> I've got a question about auditing. There is a special audit table,
> with fields like tablename, columnname, col_oldvalue. For a couple of
> tables I want to audit the table name, column name and also the
> old value of the updated column. It is possible in an afterupdate
> trigger on each
> table and compare the old en new values of the colums, but ...
> there must be a more generic way. Is anyone know with this kind of
> auditing?
> how does the sql-code look like? Or do I have to invent the wheel
> again..
Your approach is correct - after-update triggers, calling stored procedures to do the auditing.
Check http://www.serve.com/cowpb/chamilton.html and follow the link to Download the Oracle Audit Trail application - all the code is in there. Or check Chapter 13 of the new O'Reilly book "Oracle Security" - it details my application.
Chris
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 08 1999 - 10:51:29 CST