Static Data Dictionary Views, 65 of 452

ALL_POLICIES

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

USER_POLICIES describes policies on all tables and views owned by the current user. This view does not display the OBJECT_OWNER column.

See Also:

Oracle8i Concepts for information on security policies and fine-grained access control.

The DBMS_RLS packages in Oracle8i Supplied PL/SQL Packages Reference for information on administering security policies.

Column	Datatype	NULL	Description
`OBJECT_OWNER`	`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
`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)`		If YES, policy is applied to query on the object
`INS`	`VARCHAR2(3)`		If YES, policy is applied to insert on the object
`UPD`	`VARCHAR2(3)`		If YES, policy is applied to update on the object
`DEL`	`VARCHAR2(3)`		If YES, policy is applied to delete on the object
`CHK_OPTION`	`VARCHAR2(3)`		Is check option enforced for this policy?
`ENABLE`	`VARCHAR2(3)`		Is this policy enabled?