Skip to Main Content

SQL & PL/SQL

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 see the sql statements on audited tables?

3018678Oct 27 2015 — edited Oct 28 2015

Hi all,

I just audit schema as execute the following comment

AUDIT UPDATE TABLE, DELETE TABLE, INSERT TABLE BY user1, user2  BY ACCESS;

However, I couldn't find the SQL statements.

SELECT A.TIMESTAMP, A.* FROM DBA_AUDIT_TRAIL A

WHERE

USERNAME = 'USER1'

This also doesn't work, it shows empty

select sql_text from sys.aud$ where obj$name = 'TAB_PROJELOG'


Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

This post has been answered by EdStevens on Oct 27 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 25 2015
Added on Oct 27 2015
7 comments
1,433 views