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
where action_name like 'CREATE TABLE%'
Please let me know in which table should I look for..?
Click Here to Expand Forum to Full Width