ALL_AUDIT_POLICIES

ALL_AUDIT_POLICIES

ALL_AUDIT_POLICIES describes the fine-grained auditing policies on the tables and views accessible to the current user.

Related Views

DBA_AUDIT_POLICIES describes all fine-grained auditing policies in the database.
USER_AUDIT_POLICIES describes the fine-grained auditing policies on the tables and views owned by the current user. This view does not display the OBJECT_SCHEMA column.

Column	Datatype	NULL	Description
`OBJECT_SCHEMA`	`VARCHAR2(30)`	`NOT NULL`	Owner of the table or view
`OBJECT_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the table or view
`POLICY_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the policy
`POLICY_TEXT`	`VARCHAR2(4000)`		Audit condition
`POLICY_COLUMN`	`VARCHAR2(30)`		Relevant column
`PF_SCHEMA`	`VARCHAR2(30)`		Owner of the audit handler function
`PF_PACKAGE`	`VARCHAR2(30)`		Name of the package containing the audit handler function
`PF_FUNCTION`	`VARCHAR2(30)`		Name of the audit handler function
`ENABLED`	`VARCHAR2(3)`		Indicates whether the policy is enabled (`YES`) or disabled (`NO`)
`SEL`	`VARCHAR2(3)`		Indicates whether the policy is applied to queries on the object (`YES`) or not (`NO`)
`INS`	`VARCHAR2(3)`		Indicates whether the policy is applied to `INSERT` statements on the object (`YES`) or not (`NO`)
`UPD`	`VARCHAR2(3)`		Indicates whether the policy is applied to `UPDATE` statements on the object (`YES`) or not (`NO`)
`DEL`	`VARCHAR2(3)`		Indicates whether the policy is applied to `DELETE` statements on the object (`YES`) or not (`NO`)
`AUDIT_TRAIL`	`VARCHAR2(11)`		Indicates whether the `SQL_TEXT` and `SQL_BIND` columns in the fine-grained audit trail are populated for this policy (`DB_EXTENDED`) or not (`DB`)
`POLICY_COLUMN_OPTION`	`VARCHAR2(11)`		Indicates whether all columns in the `AUDIT_COLUMN` parameter (`ALL_COLUMNS`) or any of the columns in the `AUDIT_COLUMN` parameter (`ANY_COLUMNS`) are considered for triggering fine-grained auditing

See Also: