重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: ORA-46361: Audit policy cannot be dropped as it is currently enabled [打印本页]

作者: 刘泽宇 时间: 2026-8-9 18:27
标题: ORA-46361: Audit policy cannot be dropped as it is currently enabled
删除审计策略时，报错ORA-46361
SQL> DROP AUDIT POLICY TEST_CASE2;
DROP AUDIT POLICY TEST_CASE2
*
ERROR at line 1:
ORA-46361: Audit policy cannot be dropped as it is currently enabled.

报错显示处于启用状态的审计策略无法直接删除
先禁用策略：
SQL> NOAUDIT POLICY TEST_CASE2;

Noaudit succeeded.

再次删除成功
SQL> DROP AUDIT POLICY TEST_CASE2;

Audit Policy dropped.

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)