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 MAY 22, 2019

Applies to:

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 USER1,USER2;

Audit succeeded.

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

USER_NAME    ENABLED_OPT
--------------------------------------------------------------------------------
USER1               BY

USER2  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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.