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 and oe_role (for example, john), created in recipe Creating audit policies to audit privileges, actions and roles under specified conditions

• A 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...

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

   $ connect jack
   

2. 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
   

3. View which unified audit policies are enabled:

   SQL> select * from audit_unified_enabled_policies;
   

4. Connect to the database as the user john:

   SQL> connect john
   

5. Execute...