Search notes:

Oracle: DBA_POLICIES

select
   pol.object_owner,
   pol.object_name,
   pol.policy_group,
   pol.policy_name,
   pol.pf_owner,
   pol.package,
   pol.function,
   case when pol.sel = 'YES' then 'sel' end "sel",
   case when pol.ins = 'YES' then 'ins' end "ins",
   case when pol.upd = 'YES' then 'upd' end "upd",
   case when pol.del = 'YES' then 'del' end "del",
   case when pol.idx = 'YES' then 'idx' end "idx",
   pol.chk_option,
   pol.enable,
   pol.static_policy,
   pol.policy_type,
   pol.long_predicate,
   pol.common,
   pol.inherited
from
   dba_policies pol
where
-- pol.policy_name = '…'
   pol.object_name like 'TQ84_T1%';

See also

v$vpd_policy

Index