Auditing application contexts

In this recipe, you will configure auditing of information contained in an application context.

Getting ready

To complete this recipe, you'll need an existing (or predefined) application context and a user who has the audit_admin role (for example, jack).

How to do it...

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

   $ sqlplus jack
   

2. Configure application context auditing:

   SQL> AUDIT CONTEXT NAMESPACE USERENV
   ATTRIBUTES SESSION_USER, SERVICE_NAME;
   
   
   Audit succeeded.
   
   
   SQL> AUDIT CONTEXT NAMESPACE USERENV
   ATTRIBUTES HOST BY jill;
   Audit succeeded.
   

3. View for which application contexts audit data is going to be captured:

   SQL> set linesize 180
   SQL> column namespace format A30
   SQL> column attribute format A30
   SQL> column user_name format A30
   
   SQL> select * from audit_unified_contexts;
   

4. Connect user jill as follows:

   SQL> connect jill
   

5. View audit records:

   SQL> SELECT APPLICATION_CONTEXTS FROM UNIFIED_AUDIT_TRAIL...