Oracle Database 12c Security Cookbook

Enabling audit policy

In this recipe, you will learn to use different options to enable unified audit policies.

Getting ready

To complete this recipe, you'll need an existing user who has the audit_admin role (for example, jack) and several other existing users (for example, john, maja, and zoran).

How to do it...

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

   SQL> connect jack
   

2. Enable audit policy oe_policy in such way that it applies only to user JOHN

   SQL> audit policy OE_POLICY BY JOHN;
   

3. Enable audit policy hr_policy to capture only successful events.

   SQL> AUDIT POLICY HR_POLICY WHENEVER SUCCESSFUL;
   

4. Enable policy my_policy1 to audit unsuccessful events for all users except maja and zoran.

   SQL> audit policy my_policy1 ...