FAQ
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>

Search Discussions

  • Sami Seerangan at Aug 3, 2005 at 11:35 am
    Ignore my previous email. I assumed audit_trail was set whcih is not.

    Forwarded message ----------
    From: Sami Seerangan
    Date: Aug 3, 2005 12:27 PM
    Subject: audit- can someone please tell me what am I missing here?
    To: oracle-l

    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>
  • Sami Seerangan at Aug 4, 2005 at 7:11 am
    audit_trail parameter was not set. Thanks for everyone who responded.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 3, '05 at 11:29a
activeAug 4, '05 at 7:11a
posts3
users1
websiteoracle.com

1 user in discussion

Sami Seerangan: 3 posts

People

Translate

site design / logo © 2022 Grokbase