How To Exclude Users Being Audited Through the DBMS_FGA Package (Doc ID 403837.1)

Last updated on OCTOBER 13, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.3 to 12.1.0.1 [Release 10.1 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 22-Apr-2013


Goal

How to exclude a user from being audited when using the DBMS_FGA package ?

The Fine Grained Auditing Feature provides a highly flexible architecture for implementing complex Auditing requirements, this example, as taken from an actual customer case shows how to exclude a particular user from generating FGA audit records from a certain Audit Policy. The trick is to configure an audit_condition that matches the business requirements, several other attributes besides SESSION_USER are available in the USERENV namespace that can be used to build a suitable condition.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms