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: Lyndon Tiu <ltiu_at_alumni.sfu.ca>
Date: Wed, 15 Aug 2007 06:14:13 -0700
Message-Id: <200708151314.l7FDEDFc023431@rm-rstar.sfu.ca>

If I did not have audit any priv, would this sql have failed?

audit update table;

I ran this command successfully:

SQL> audit update table;

Audit succeeded.

On Wed, 15 Aug 2007 15:08:47 0200 alvaro.fernandez_at_sivsa.com wrote:
>
> 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.

--
Lyndon Tiu
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 15 2007 - 08:14:13 CDT

Original text of this message

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