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.
To complete this recipe, you'll need an existing user who has the DBA role (for example, maja
).
Connect to the database as a user who has the dba role (for example,
maja
):$ sqlplus maja
Create the user
jack
and grant him thecreate session
privilege and theaudit_admin
role.SQL> create user jack identified by pQ3s7a4w2; SQL> grant create session, audit_admin to jack;
Create the user
jill
and grant her thecreate session
privilege and theaudit_viewer
role.SQL> create user jill identified by t1m5_R2f3; SQL> grant create session, audit_viewer to jill;