Oracle Database 12c Security Cookbook

Which roles do you need to have to be able to create audit policies and to view audit data?

In this recipe, you're going to create two users (for example, jack and jill). Jack's job is to implement auditing requirements and to make sure that auditing is functioning properly. Jill is an auditor and her job is to analyze audit data.

Getting ready

To complete this recipe, you'll need an existing user who has the DBA role (for example, maja).

How to do it...

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

   $ sqlplus maja
   

2. Create the user jack and grant him the create session privilege and the audit_admin role.

   SQL> create user jack identified by pQ3s7a4w2;
   
   SQL> grant create session, audit_admin to jack; 
   

3. Create the user jill ...