VIEW: SYS.ALL_POLICIES

Source

View Text - Preformatted

SELECT OBJECT_OWNER, OBJECT_NAME, POLICY_GROUP, POLICY_NAME, PF_OWNER,
PACKAGE, FUNCTION, SEL, INS, UPD, DEL, IDX, CHK_OPTION, ENABLE, STATIC_POLICY,
POLICY_TYPE, LONG_PREDICATE
FROM DBA_POLICIES, ALL_TABLES t
WHERE
(OBJECT_OWNER = t.OWNER AND OBJECT_NAME = t.TABLE_NAME)
union all
SELECT OBJECT_OWNER, OBJECT_NAME, POLICY_GROUP, POLICY_NAME, PF_OWNER,
PACKAGE, FUNCTION, SEL, INS, UPD, DEL, IDX, CHK_OPTION, ENABLE, STATIC_POLICY,
POLICY_TYPE, LONG_PREDICATE
FROM DBA_POLICIES, ALL_VIEWS v
WHERE
(OBJECT_OWNER = v.OWNER AND OBJECT_NAME = v.VIEW_NAME )
union all
SELECT OBJECT_OWNER, OBJECT_NAME, POLICY_GROUP, POLICY_NAME, PF_OWNER,
PACKAGE, FUNCTION, SEL, INS, UPD, DEL, IDX, CHK_OPTION, ENABLE, STATIC_POLICY,
POLICY_TYPE, LONG_PREDICATE
FROM DBA_POLICIES, ALL_SYNONYMS s
WHERE
(OBJECT_OWNER = s.OWNER AND OBJECT_NAME = s.SYNONYM_NAME)

View Text - HTML Formatted

SELECT OBJECT_OWNER
, OBJECT_NAME
, POLICY_GROUP
, POLICY_NAME
, PF_OWNER
, PACKAGE
, FUNCTION
, SEL
, INS
, UPD
, DEL
, IDX
, CHK_OPTION
, ENABLE
, STATIC_POLICY
, POLICY_TYPE
, LONG_PREDICATE FROM DBA_POLICIES
, ALL_TABLES T WHERE (OBJECT_OWNER = T.OWNER
AND OBJECT_NAME = T.TABLE_NAME) UNION ALL SELECT OBJECT_OWNER
, OBJECT_NAME
, POLICY_GROUP
, POLICY_NAME
, PF_OWNER
, PACKAGE
, FUNCTION
, SEL
, INS
, UPD
, DEL
, IDX
, CHK_OPTION
, ENABLE
, STATIC_POLICY
, POLICY_TYPE
, LONG_PREDICATE FROM DBA_POLICIES
, ALL_VIEWS V WHERE (OBJECT_OWNER = V.OWNER
AND OBJECT_NAME = V.VIEW_NAME ) UNION ALL SELECT OBJECT_OWNER
, OBJECT_NAME
, POLICY_GROUP
, POLICY_NAME
, PF_OWNER
, PACKAGE
, FUNCTION
, SEL
, INS
, UPD
, DEL
, IDX
, CHK_OPTION
, ENABLE
, STATIC_POLICY
, POLICY_TYPE
, LONG_PREDICATE FROM DBA_POLICIES
, ALL_SYNONYMS S WHERE (OBJECT_OWNER = S.OWNER
AND OBJECT_NAME = S.SYNONYM_NAME)