Finding information about audit policies and audited data
In this recipe, you will view audited data and find information about unified audit policies.
Getting ready
To complete this recipe, you'll need three existing users:
A user who has
audit_admin
role (for example,jack
)A user who has
hr_role
andoe_role
(for example,john
), created in recipe Creating audit policies to audit privileges, actions and roles under specified conditionsA user who has
admin_viewer
role (for example,jill
)
Also, you'll need to connect to the database as SYS
user.
How to do it...
Connect to the database as a user who has the
audit_admin
role (for example,jack
):$ connect jack
Find which unified audit policies are defined (exist in the database):
SQL> select distinct policy_name from audit_unified_policies; SQL> desc audit_unified_policies
View which unified audit policies are enabled:
SQL> select * from audit_unified_enabled_policies;
Connect to the database as the user
john
:SQL> connect john
Execute...