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: Audit Trail

Re: Audit Trail

From: Karl M. Nordquist <karln_at_brightwood.com>
Date: 1997/02/26
Message-ID: <33146360.D36@brightwood.com>#1/1

anupcomp_at_giasbm01.vsnl.net.in wrote:

>... 

> I have given
>
> audit select table by access whenever not successful
>...

> However, I want to have the complete text of the select statement that
> failed. How should I get this?

According to the Administrator's Guide, on page 13-5, it states that no data values are recorded in the audit information, and that it could be done with triggers instead. On page 13-20, the trigger method is fully described.

HTH Regards

//Karl

-- 
====================================================
Karl M. Nordquist		karln_at_brightwood.com
Application Development
Bright Wood Corporation
Madras, Oregon
====================================================
Received on Wed Feb 26 1997 - 00:00:00 CST

Original text of this message

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