DBA_POLICIES

All row level security policies in the database

Columns
   ___________________________
 
   OBJECT_OWNER
      Owner of the synonym,table,or view
   OBJECT_NAME
      Name of the synonym,table,or view
   POLICY_GROUP
      Name of the 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:

DBA_SEC_RELEVANT_COLS
DBA_POLICY_GROUPS
DBA_POLICY_ATTRIBUTES
DBA_POLICY_CONTEXTS
DBA_PROFILES