ALL_AUDIT_POLICIES

Previous Next JavaScript must be enabled to correctly display this content

3.114 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(128)`		Name of the schema that includes the table or view
`OBJECT_NAME`	`VARCHAR2(128)`		Name of the table or view
`POLICY_OWNER`	`VARCHAR2(128)`		Owner of the policy
`POLICY_NAME`	`VARCHAR2(128)`		Name of the policy
`POLICY_TEXT`	`VARCHAR2(4000)`		Audit condition
`POLICY_COLUMN`	`VARCHAR2(128)`		This column is deprecated. Query the ALL_AUDIT_POLICY_COLUMNS view for fine-grained auditing policy column information.
`PF_SCHEMA`	`VARCHAR2(128)`		Owner of the audit handler function
`PF_PACKAGE`	`VARCHAR2(128)`		Name of the package containing the audit handler function
`PF_FUNCTION`	`VARCHAR2(128)`		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(12)`		Indicates the audit trail to which the audit records generated by this audit policy will be written: `DB` - Audit records are written to `DBA_FGA_AUDIT_TRAIL` (fine-grained audit trail) `DB+EXTENDED` - Audit records are written to `DBA_FGA_AUDIT_TRAIL` (fine-grained audit trail) and the `SQL_TEXT` and `SQL_BIND` columns are populated for this policy `XML` - Audit records are written to `V$XML_AUDIT_TRAIL` (XML audit files) `XML+EXTENDED` - Audit records are written to `V$XML_AUDIT_TRAIL` (XML audit files) and the `SQL_TEXT` and `SQL_BIND` columns are populated for this policy
`POLICY_COLUMN_OPTIONS`	`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
`COMMON`	`VARCHAR2(3)`		Indicates whether the policy applies across multiple containers (`YES`) or not (`NO`)
`INHERITED`	`VARCHAR2(3)`		Indicates whether the policy was inherited from another container (`YES`) or not (`NO`)

See Also: