Re: Auditing and statement execution failures ?

From: Christian Mondrup <reccmo_at_uts.uni-c.dk>
Date: 27 Apr 92 10:50:38 GMT
Message-ID: <1992Apr27.105038.11851_at_uts.uni-c.dk>


In <1992Apr26.163350.1_at_vxcrna.cern.ch> roeber_at_vxcrna.cern.ch writes:

>I have a question about auditing:
 

>Audit records are written after a statement is parsed, not executed.
 

>So if I audit insertions on a table "whenever successful," and then
>make an insertion which parses fine but which has an execution-time
>failure (like a duplicate unique value) and therefore doesn't execute,
>an audit record is still written showing it succeeded, yes?

That's precisely what I have found too. I have tried - in vain - to get our ORACLE support to confirm that the behaviour af ORACLE auditing is so.

To put it more general: the ORACLE auditing features will meet only a small part of the security and logging demands of a database system as they are stated in typical danish registry prescripts.

-- 
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+      Christian Mondrup                                                      +
+      UNI-C Aarhus, Danish Computing Centre for Research and Education.      +
+      Olof Palmes Alle 38, DK 8200 Aarhus N.                                 +
+                                                                             +
+      Phone:   +45 86 78 44 44                                               +
+      Telefax: +45 86 78 44 55                                               +
+      E-Mail:  Christian.Mondrup_at_uni-c.dk                                    +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Received on Mon Apr 27 1992 - 12:50:38 CEST

Original text of this message