RE: AUDIT sql command question

  • From: <Joel.Patterson@xxxxxxxxxxx>
  • To: <ltiu@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 15 Aug 2007 08:47:25 -0400

Did you set audit_trail=DB in the init file and restart?

Show parameter audit
audit_trail                          string      DB

Joel Patterson
Database Administrator
904  727-2546

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Lyndon Tiu
Sent: Wednesday, August 15, 2007 7:14 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: AUDIT sql command question

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

Lyndon Tiu


Other related posts: