VIEW: LBACSYS.DBA_SA_TABLE_POLICIES

Source

View Text - Preformatted

SELECT t.policy_name, schema_name, table_name, t.status,
         table_options, function, predicate
  FROM LBACSYS.dba_lbac_policies p, LBACSYS.dba_lbac_table_policies t
  WHERE p.policy_name=t.policy_name
    AND p.package='LBAC$SA'

View Text - HTML Formatted

SELECT T.POLICY_NAME
, SCHEMA_NAME
, TABLE_NAME
, T.STATUS
, TABLE_OPTIONS
, FUNCTION
, PREDICATE
FROM LBACSYS.DBA_LBAC_POLICIES P
, LBACSYS.DBA_LBAC_TABLE_POLICIES T
WHERE P.POLICY_NAME=T.POLICY_NAME
AND P.PACKAGE='LBAC$SA'