VIEW: SYS.ALL_SEC_RELEVANT_COLS

Source

View Text - Preformatted

SELECT OBJECT_OWNER, OBJECT_NAME, POLICY_GROUP, POLICY_NAME,
       SEC_REL_COLUMN, COLUMN_OPTION
from DBA_SEC_RELEVANT_COLS, 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,
       SEC_REL_COLUMN, COLUMN_OPTION
from DBA_SEC_RELEVANT_COLS, ALL_VIEWS v
WHERE
(OBJECT_OWNER = v.OWNER AND OBJECT_NAME = v.VIEW_NAME )

View Text - HTML Formatted

SELECT OBJECT_OWNER
, OBJECT_NAME
, POLICY_GROUP
, POLICY_NAME
, SEC_REL_COLUMN
, COLUMN_OPTION FROM DBA_SEC_RELEVANT_COLS
, 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
, SEC_REL_COLUMN
, COLUMN_OPTION FROM DBA_SEC_RELEVANT_COLS
, ALL_VIEWS V WHERE (OBJECT_OWNER = V.OWNER
AND OBJECT_NAME = V.VIEW_NAME )