ALL_POLICIES

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

Related Views

• DBA_POLICIES describes all policies in the database.

• 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: Oracle9i Database Concepts for information on security policies and fine-grained access control The DBMS_RLS packages in Oracle9i Supplied PL/SQL Packages and Types 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?