Auditing Oracle business processes?

  • From: "Denham Eva" <EVAD@xxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 10 Aug 2005 14:49:51 +0200

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
--
//www.freelists.org/webpage/oracle-l

Other related posts: