Unified Auditing Oracle 12c
Hi,
I am testing unified auditing in 12c and have a simple question hopefully. I created the following policy
CREATE AUDIT POLICY QUBE_INDEX_AUDIT
ACTIONS CREATE INDEX, DROP INDEX, ALTER INDEX;
AUDIT POLICY QUBE_INDEX_AUDIT;
I then ran:
create index testi1 on test (SKYC_DATE_VAL_FLAG);
AND Also
drop index testi1 on test (SKYC_DATE_VAL_FLAG);
On running the following query I noticed the drop command is not audited
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';
select dbusername,event_timestamp,sql_text,CLIENT_PROGRAM_NAME,OBJECT_SCHEMA,OBJECT_NAME,ACTION_NAME,OS_USERNAME,TERMINAL,AUDIT_TYPE,UNIFIED_AUDIT_POLICIES