ALL_POLICIES

3.13 ALL_POLICIES

ALL_POLICIES describes all Oracle Virtual Private Database (VPD) security policies for objects accessible to the current user. A security policy is a list of security requirements and rules that regulate row level access to those database objects.

Related Views

DBA_POLICIES describes all Oracle Virtual Private Database (VPD) security policies in the database.
USER_POLICIES describes all Oracle Virtual Private Database (VPD) security policies associated with objects owned by the current user. This view does not display the OBJECT_OWNER column.

Column	Datatype	Description
`OBJECT_OWNER`	`VARCHAR2(128)`	Owner of the synonym, table, or view
`OBJECT_NAME`	`VARCHAR2(128)`	Name of the synonym, table, or view
`POLICY_GROUP`	`VARCHAR2(128)`	Name of the policy group
`POLICY_NAME`	`VARCHAR2(128)`	Name of the policy
`PF_OWNER`	`VARCHAR2(128)`	Owner of the policy function
`PACKAGE`	`VARCHAR2(128)`	Name of the package containing the policy function
`FUNCTION`	`VARCHAR2(128)`	Name of the policy function
`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`)
`IDX`	`VARCHAR2(3)`	Indicates whether the policy is enforced for index maintenance on the object (`YES`) or not (`NO`)
`CHK_OPTION`	`VARCHAR2(3)`	Indicates whether the check option is enforced for the policy (`YES`) or not (`NO`)
`ENABLE`	`VARCHAR2(3)`	Indicates whether the policy is enabled (`YES`) or disabled (`NO`)
`STATIC_POLICY`	`VARCHAR2(3)`	Indicates whether the policy is static (`YES`) or not (`NO`). This column is obsolete because information about static policies is shown in the `POLICY_TYPE` column.
`POLICY_TYPE`	`VARCHAR2(24)`	Policy type: `STATIC` `SHARED_STATIC` `CONTEXT_SENSITIVE` `SHARED_CONTEXT_SENSITIVE` `DYNAMIC`
`LONG_PREDICATE`	`VARCHAR2(3)`	Indicates whether the policy function can return a maximum of 32 KB of predicate (`YES`) or not (`NO`). If `NO`, the default maximum predicate size is `4000` bytes.
`COMMON`^Foot 1	`VARCHAR2(3)`	Indicates whether the policy is applied and enforced in all application PDBs (`YES`) or only in the local PDB (`NO`) This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`INHERITED`	`VARCHAR2(3)`	Indicates whether the policy is inherited from the root (`YES`) or not (`NO`) This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

^Footnote 1