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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: AUDIT sql command question

RE: AUDIT sql command question

From: Alvaro Jose Fernandez <alvaro.fernandez_at_sivsa.com>
Date: Wed, 15 Aug 2007 15:08:47 +0200
Message-ID: <607D6181D9919041BE792D70EF2AEC481CFF93@LIMENS.sivsa.int>

Hi,

You have AUDIT ANY privilege to your user?

AUDIT INSERT, UPDATE, DELETE
ON <======
<table> ;

?    

 Álvaro Fernández

---
 

SQL> show parameter audit_trail
 
NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
audit_trail                          string      DB


Any more ideas on what could be wrong?


On Wed, 15 Aug 2007 13:40:01  0100 niall.litchfield_at_gmail.com wrote:

> Where you audit to is controlled by the AUDIT_TRAIL parameter IIRC.
>
> On 15/08/07, Lyndon Tiu <ltiu_at_alumni.sfu.ca> wrote:
> > I ran:
> >
> > SQL> audit insert table, update table, delete table;
> >
> > Audit succeeded.
-- http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 15 2007 - 08:08:47 CDT

Original text of this message

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