Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: AUDIT sql command question
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-lReceived on Wed Aug 15 2007 - 08:14:13 CDT
![]() |
![]() |