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...
- 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 ...
Get Oracle Database 12c Security Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.