VIEW: SYS.ALL_POLICY_CONTEXTS

Source

View Text - Preformatted

SELECT OBJECT_OWNER, OBJECT_NAME,NAMESPACE,ATTRIBUTE
FROM DBA_POLICY_CONTEXTS, ALL_TABLES t
WHERE
(OBJECT_OWNER = t.OWNER AND OBJECT_NAME = t.TABLE_NAME)
union all
SELECT OBJECT_OWNER, OBJECT_NAME,NAMESPACE,ATTRIBUTE
FROM DBA_POLICY_CONTEXTS, ALL_VIEWS v
WHERE
(OBJECT_OWNER = v.OWNER AND OBJECT_NAME = v.VIEW_NAME )
union all
SELECT OBJECT_OWNER, OBJECT_NAME,NAMESPACE,ATTRIBUTE
FROM DBA_POLICY_CONTEXTS, ALL_SYNONYMS s
WHERE
(OBJECT_OWNER = s.OWNER AND OBJECT_NAME = s.SYNONYM_NAME )

View Text - HTML Formatted

SELECT OBJECT_OWNER
, OBJECT_NAME
, NAMESPACE
, ATTRIBUTE FROM DBA_POLICY_CONTEXTS
, ALL_TABLES T WHERE (OBJECT_OWNER = T.OWNER
AND OBJECT_NAME = T.TABLE_NAME) UNION ALL SELECT OBJECT_OWNER
, OBJECT_NAME
, NAMESPACE
, ATTRIBUTE FROM DBA_POLICY_CONTEXTS
, ALL_VIEWS V WHERE (OBJECT_OWNER = V.OWNER
AND OBJECT_NAME = V.VIEW_NAME ) UNION ALL SELECT OBJECT_OWNER
, OBJECT_NAME
, NAMESPACE
, ATTRIBUTE FROM DBA_POLICY_CONTEXTS
, ALL_SYNONYMS S WHERE (OBJECT_OWNER = S.OWNER
AND OBJECT_NAME = S.SYNONYM_NAME )