Oracle Database 12c Security Cookbook

Disabling and dropping audit policies

In this recipe, you will learn to disable and drop audit policies.

Getting ready

To complete this recipe, you'll need an enabled unified audit policy (for example, oe_policy) and a user who has the audit_admin role (for example, jack).

How to do it...

1. Connect to the database as a user who has the audit_admin role (for example, jack):

   $ sqlplus jack
   

2. Verify that the policy is enabled:

   SQL> SELECT POLICY_NAME, ENABLED_OPT, USER_NAME,
   SUCCESS, FAILURE
   FROM AUDIT_UNIFIED_ENABLED_POLICIES;
   

3. Disable the policy oe_policy:

   SQL> NOAUDIT policy oe_policy BY JOHN;
   

4. Verify that oe_policy is disabled:

   SQL> select * from AUDIT_UNIFIED_ENABLED_POLICIES;
   

5. Drop the policy oe_policy:

   SQL> drop audit policy oe_policy;
   

How it works... ...