In this recipe, you will learn to use different options to enable unified audit policies.
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
).
Connect to the database as a user who has
audit_admin
role (for example,jack
)SQL> connect jack
Enable audit policy
oe_policy
in such way that it applies only to userJOHN
SQL> audit policy OE_POLICY BY JOHN;
Enable audit policy
hr_policy
to capture only successful events.SQL> AUDIT POLICY HR_POLICY WHENEVER SUCCESSFUL;
Enable policy
my_policy1
to audit unsuccessful events for all users exceptmaja
andzoran
.SQL> audit policy my_policy1 EXCEPT MAJA, ZORAN WHENEVER NOT SUCCESSFUL;
Enable audit policy
role_con_policy
using default options.SQL> audit policy role_con_policy;