Database Administration (MOSC)

MOSC Banner

Unified Auditing Oracle 12c

edited Jan 25, 2018 4:00AM in Database Administration (MOSC) 3 commentsAnswered

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  

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