Oracle PL/SQL for DBAs

Name

DBA_AUDIT_POLICIES

Synopsis

This view shows the FGA policies created on the database.

		Oracle Database version
Column name	Description	9i	10g
OBJECT_SCHEMA	Owner of the table on which the policy is defined.	Yes	Yes
OBJECT_NAME	Name of the table on which the policy is defined.	Yes	Yes
POLICY_NAME	Name of the defined policy.	Yes	Yes
POLICY_TEXT	Condition under which the auditing should be triggered (e.g., “SALARY>1500”) is recorded here.	Yes	Yes
POLICY_COLUMN	Columns whose selection triggers the audit.	Yes	Yes
PF_SCHEMA	If the policy has a handler module, its owner is recorded here. The handler module executes automatically when the audit condition is satisfied.	Yes	Yes
PF_PACKAGE	If the handler module is a packaged procedure, the name of package is recorded here.	Yes	Yes
PF_FUNCTION	Name of the handler. If the handler module is a packaged procedure, this column shows the name of the procedure.	Yes	Yes
ENABLED	Indicates whether the policy is currently enabled.	Yes	Yes
SEL	Indicates whether the policy applies to SELECT statements.	No	Yes
INS	Indicates whether the policy applies to INSERT statements	No	Yes
UPD	Indicates whether the policy applies to UPDATE statements.	No	Yes
DEL	Indicates whether the policy applies to DELETE statements.	No	Yes
AUDIT_TRAIL	Type of auditing. If the value is DB_EXTENDED, it records bind variables in the trail. If the value is DB, bind variables are not recorded. In Oracle Database 10g Release ...