Database Administration (MOSC)

MOSC Banner

[Oracle DB 11gR2] Auditing dropped indexes

edited Oct 18, 2014 10:00AM in Database Administration (MOSC) 2 commentsAnswered

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             SUCCESSFAILURE

------- ----- ------------------------- ---------- ----------

          DROP ANY INDEX        BY ACCESS  BY ACCESS
TEST_AU  
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center