Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find SQL Statement fired using SYS.AUD$ - Database Auditing

437390Dec 13 2007 — edited Dec 13 2007
Dear Friends

I am having Oracle 9i Database and have configured it with database auditing option by setting the following parameter in init.ora file
AUDIT_TRAIL = "DB"

I want to audit SELECT, INSERT , UPDATE and DELETE operations on PRACTICE.EMP table for which I did :

1) Logged in as SYS

2) SQL> AUDIT SELECT, INSERT, UPDATE, DELETE
ON PRACTICE.EMP
BY ACCESS
WHENEVER SUCCESSFUL;
Audit Succedded

Now how should I find out the SQL statement that does the insert, update or delete operation on the EMP table using SYS.AUD$ table

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 10 2008
Added on Dec 13 2007
2 comments
1,553 views