ALL_POLICIES

All policies for objects if the user has system privileges or owns the objects

Columns
   ___________________________
 
   POLICY_NAME
      Name of the policy
   INS
      If YES, policy is applied to insert on the object
   ENABLE
      Is this policy is enabled?
   CHK_OPTION
      Is check option enforced for this policy?
   DEL
      If YES, policy is applied to delete on the object
   UPD
      If YES, policy is applied to update on the object
   SEL
      If YES, policy is applied to query on the object
   FUNCTION
      Name of the policy function
   PF_OWNER
      Owner of the policy function
   OBJECT_NAME
      Name of the table or view
   OBJECT_OWNER
      Owner of the table or view
   PACKAGE
      Name of the package containing the policy function

Related Commands:

Simon Sheppard
SS64.com