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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
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