|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 2 (9.2)
Part Number A96612-01
DBMS_FGA package provides fine-grained security functions. Execute privilege on
DBMS_FGA is needed for administering audit policies. Because the audit function can potentially capture all user environment and application context values, policy administration should be executable by privileged users only.
Oracle9i Application Developer's Guide - Fundamentals for a fuller discussion and more usage information on
This feature is available for only cost-based optimization. The rule-based optimizer may generate unnecessary audit records since audit monitoring can occur before row filtering. For both the rule-based optimizer and the cost-based optimizer, you can refer to
DBA_FGA_AUDIT_TRAIL to analyze the SQL text and corresponding bind variables that are issued.
This chapter discusses the following topics: