Static Data Dictionary Views, 106 of 666

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	Description
`OBJECT_OWNER`	`VARCHAR2(30)`	Owner of the synonym, table, or view
`OBJECT_NAME`	`VARCHAR2(30)`	Name of the synonym, table, or view
`POLICY_GROUP`	`VARCHAR2(30)`	Name of the policy group
`POLICY_NAME`	`VARCHAR2(30)`	Name of the policy
`PF_OWNER`	`VARCHAR2(30)`	Owner of the policy function
`PACKAGE`	`VARCHAR2(30)`	Name of the package containing the policy function
`FUNCTION`	`VARCHAR2(30)`	Name of the policy function
`SEL`	`VARCHAR2(3)`	Indicates whether the policy is applied to query on the object (`YES`) or not (`NO`)
`INS`	`VARCHAR2(3)`	Indicates whether the policy is applied to insert on the object (`YES`) or not (`NO`)
`UPD`	`VARCHAR2(3)`	Indicates whether the policy is applied to update on the object (`YES`) or not (`NO`)
`DEL`	`VARCHAR2(3)`	Indicates whether the policy is applied to delete 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`)

See Also:

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