AUDIT sql command question 2007-08-15 - By Lyndon Tiu
Back
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@(protected) 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@(protected) wrote:
> > Where you audit to is controlled by the AUDIT_TRAIL parameter IIRC.
> >
> > On 15/08/07, Lyndon Tiu <ltiu@(protected)> wrote:
> > > I ran:
> > >
> > > SQL> audit insert table, update table, delete table;
> > >
> > > Audit succeeded.
--
Lyndon Tiu
--
http://www.freelists.org/webpage/oracle-l
|
|
