ALL_POLICIES

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

Columns
   ___________________________
 
   OBJECT_OWNER
      Owner of the synonym,table,or view
   OBJECT_NAME
      Name of the synonym,table,or view
   POLICY_GROUP
      --
   POLICY_NAME
      Name of the policy
   PF_OWNER
      Owner of the policy function
   PACKAGE
      Name of the package containing the policy function
   FUNCTION
      Name of the policy function
   SEL
      If YES
   INS
      If YES
   UPD
      If YES
   DEL
      If YES
   CHK_OPTION
      Is check option enforced for this policy?
   ENABLE
      Is this policy is enabled?
   STATIC_POLICY
      Is this policy is static?

Related:

Simon Sheppard
SS64.com