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 => Database Auditing

437390Dec 14 2007 — edited Dec 15 2007
Dear All

I have configured Database Auditing on Oracle 9i Enterprise Edition Server

parameter init.ora file:

AUDIT_TRAIL = "DB"

I want to audit INSERT,UPDATE, DELETE STATEMENT on PRACTICE.EMP table
for which i did :

1) Logged in as SYS
SQL> AUDIT INSERT,UPDATE,DELETE
ON PRACTICE.EMP
BY ACCESS
WHENEVER SUCCESSFUL
Audit Succedded

2) Now I have to check the SQL statement that did insert update or delete operation using SYS.AUD$

3) There is SQLTEXT field , datatype is CLOB.

How should I check the SQL Statements that were fired on PRACTICE.EMP table

Kindly help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 12 2008
Added on Dec 14 2007
14 comments
5,681 views