Re: Auditing and statement execution failures ?
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