Oracle Database 12c Security Cookbook

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