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...
- Connect to the database as a user who has the
audit_admin
role (for example,jack
):$ sqlplus jack
- 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.
- View for which application contexts audit data is going to be captured:
SQL> set linesize 180 SQL> column namespace format A30 SQL> column attribute ...
Get Oracle Database 12c Security Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.