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 05:57:22 -0700
Message-Id: <200708151257.l7FCvM35006073@rm-rstar.sfu.ca>


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.
> >
> > Then I did some updates on a few tables owned by myself. But I see no
> > entries in the sys.aud$ table recording my activities. What am I missing?
> >
> > --
> > Lyndon Tiu
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info

--
Lyndon Tiu
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 15 2007 - 07:57:22 CDT

Original text of this message

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