[Oracle DB 11gR2] Auditing dropped indexes
Hello,
I am trying to figure out how to "audit" the schema structure modifications and more precisely, the drop index action.
Here is my current setup:
sho parameter audit
=>
audit_file_dest | string | /oradata/oraaa001/admin/adump |
audit_syslog_level | string | |
audit_sys_operations | boolean | FALSE |
audit_trail | string | DB |
=> I have tried these:
AUDIT DROP ANY INDEX;
AUDIT DROP ANY INDEX by test_audit;
=> confirmed by:
select * from sys.dba_priv_audit_opts where privilege like 'DROP%INDEX%';
USER_NA PROXY PRIVILEGE | SUCCESS | FAILURE |
------- ----- ------------------------- ---------- ----------
DROP ANY INDEX | BY ACCESS BY ACCESS | |
TEST_AU |