In this recipe, you will view audited data and find information about unified audit policies.
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.
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...