-
Oracle AUDIT
I am trying to audit the 'CREATE TABLE' for all the users.
I executed AUDIT CREATE TABLE BY SYS, SYSTEM and also AUDIT CREATE ANY TABLE and audit successfully started. Then I created the table thru SYS - CREATE TABLE TEST (NU NUMBER);
Now I am trying to audit this and do not know how to look for the information. I tried this below and but didn't get results.
select action, action_name, username
from dba_audit_trail
where action_name like 'CREATE TABLE%'
Please let me know in which table should I look for..?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|