Dropping a unified audit policy errors with ORA-46361: Audit policy cannot be dropped as it is currently enabled. (Doc ID 2207300.1)

Last updated on NOVEMBER 24, 2016

Applies to:

Oracle Database - Standard Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

In 12c oracle database a unified auditing policy is created and later you wanted to drop that policy. But doing so errors with ORA-46361: Audit policy cannot be dropped as it is currently enabled.

Changes

 Created unified audit policy and trying to drop it.

 

SQL> create audit policy audit_all_chg actions update, insert, delete ;

Audit policy created.

SQL> audit policy audit_all_chg by TIGER,GSMCATUSER;

Audit succeeded.

 

SQL> select USER_NAME,enabled_opt from audit_unified_enabled_policies where policy_name='AUDIT_ALL_CHG';

USER_NAME    ENABLED_OPT
--------------------------------------------------------------------------------
TIGER               BY

GSMCATUSER  BY

 

SQL> noaudit policy audit_all_chg;

Noaudit succeeded.

SQL> drop audit policy audit_all_chg;
drop audit policy audit_all_chg
*
ERROR at line 1:
ORA-46361: Audit policy cannot be dropped as it is currently enabled.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms