VIEW: SYS.ALL_POLICY_GROUPS

Source

View Text - Preformatted

SELECT OBJECT_OWNER, OBJECT_NAME, POLICY_GROUP
FROM DBA_POLICY_GROUPS, ALL_TABLES t
WHERE
(OBJECT_OWNER = t.OWNER AND OBJECT_NAME = t.TABLE_NAME)
union all
SELECT OBJECT_OWNER, OBJECT_NAME, POLICY_GROUP
FROM DBA_POLICY_GROUPS, ALL_VIEWS v
WHERE
(OBJECT_OWNER = v.OWNER AND OBJECT_NAME = v.VIEW_NAME )
union all
SELECT OBJECT_OWNER, OBJECT_NAME, POLICY_GROUP
FROM DBA_POLICY_GROUPS, 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 FROM DBA_POLICY_GROUPS
, ALL_TABLES T WHERE (OBJECT_OWNER = T.OWNER
AND OBJECT_NAME = T.TABLE_NAME) UNION ALL SELECT OBJECT_OWNER
, OBJECT_NAME
, POLICY_GROUP FROM DBA_POLICY_GROUPS
, ALL_VIEWS V WHERE (OBJECT_OWNER = V.OWNER
AND OBJECT_NAME = V.VIEW_NAME ) UNION ALL SELECT OBJECT_OWNER
, OBJECT_NAME
, POLICY_GROUP FROM DBA_POLICY_GROUPS
, ALL_SYNONYMS S WHERE (OBJECT_OWNER = S.OWNER
AND OBJECT_NAME = S.SYNONYM_NAME)