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

Home -> Community -> Mailing Lists -> Oracle-L -> Auditing Oracle business processes?

Auditing Oracle business processes?

From: Denham Eva <EVAD_at_TFMC.co.za>
Date: Wed, 10 Aug 2005 14:49:51 +0200
Message-ID: <B822F724868AE8419D78F162BE7C2DB601EC3153@cent12000.tfmc.co.za>


Hello Group

I have had an unusual request (at least it is for me). I have been asked if there is some way to audit the Oracle Processes within the Database.
Some thing along the line of, how can I prove that when the user enters data into the database that all the relevant triggers kick off and all the relevant procedures/packages etc are accessed, also the application is operating correctly at db level.
Now my logic says that checking that garbage IN and checking Garbage OUT and the correctness of the garbage would be an indication of "correct procedural execution"; does not seem to excite Management quite as I had hoped.
Also Management seems to have the impression that databases have an internal system of being able to do this?? Is this so? Beyond the obvious Auditing functions of who did what when etc (Tried explaining that, got the glazed look).

Does anyone have (Know of) some other method?

TIA
Best Regards
Denham

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 10 2005 - 07:53:28 CDT

Original text of this message

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