Re: AUDIT sql command question
- From: Lyndon Tiu <ltiu@xxxxxxxxxxxxx>
- To: alvaro.fernandez@xxxxxxxxx
- Date: Wed, 15 Aug 2007 06:14:13 -0700
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@xxxxxxxxx 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@xxxxxxxxx wrote:
> > Where you audit to is controlled by the AUDIT_TRAIL parameter IIRC.
> >
> > On 15/08/07, Lyndon Tiu <ltiu@xxxxxxxxxxxxx> wrote:
> > > I ran:
> > >
> > > SQL> audit insert table, update table, delete table;
> > >
> > > Audit succeeded.
--
Lyndon Tiu
--
//www.freelists.org/webpage/oracle-l
Other related posts:
