My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.