Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: auditing....

Re: auditing....

From: <toneczar_at_erols.com>
Date: Mon, 08 Feb 1999 16:51:29 GMT
Message-ID: <79n4mc$7dv$1@nnrp1.dejanews.com>


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



Chris Hamilton -- toneczar_at_erols.com
http://www.serve.com/cowpb/chamilton.html City of Washington Pipe Band

-----------== 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US