ALL_POLICIES

ALL_POLICIES

ALL_POLICIES describes the security policies on the synonyms, tables, and views accessible to the current user.

Related Views

DBA_POLICIES describes all security policies in the database.
USER_POLICIES describes the security policies on the synonyms, tables, and views owned by the current user. This view does not display the OBJECT_OWNER column.

Column	Datatype	NULL	Description
`OBJECT_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the synonym, table, or view
`OBJECT_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the synonym, table, or view
`POLICY_GROUP`	`VARCHAR2(30)`	`NOT NULL`	Name of the policy group
`POLICY_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the policy
`PF_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the policy function
`PACKAGE`	`VARCHAR2(30)`		Name of the package containing the policy function
`FUNCTION`	`VARCHAR2(30)`	`NOT NULL`	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`)
`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.

See Also:

"DBA_POLICIES"
"USER_POLICIES"
Oracle Database Concepts for information on security policies and fine-grained access control
The DBMS_RLS package in PL/SQL Packages and Types Reference for information on administering security policies