Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> audit- can someone please tell me what am I missing here?

audit- can someone please tell me what am I missing here?

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Wed, 3 Aug 2005 12:27:35 -0400
Message-ID: <f09dd628050803092778d86d66@mail.gmail.com>


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-l
Received on Wed Aug 03 2005 - 11:29:34 CDT

Original text of this message

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