Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> audit- can someone please tell me what am I missing here?
I am sorry If the question is very basic. I wanted to audit everything
for a particular user.
This is what I tried but I couldn't find any audit entry.
C:\>sqlplus sys/welcome as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 3 12:20:10 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> audit all by sami by access;
Audit succeeded.
SQL> connect sami/sami
Connected.
SQL> insert into t1 values(40);
1 row created.
SQL> commit;
Commit complete.
SQL> delete t1 where c1=20;
1 row deleted.
SQL> commit;
Commit complete.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
C:\>sqlplus sys/welcome as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 3 12:21:14 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select * from aud$;
no rows selected
SQL> select * from dba_audit_trail;
no rows selected
SQL> select * from dba_audit_session;
no rows selected
SQL> select * from dba_audit_object;
no rows selected
SQL>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 03 2005 - 11:29:34 CDT