VIEW: SYS.ALL_AUDIT_POLICIES

Source

View Text - Preformatted

SELECT OBJECT_SCHEMA, OBJECT_NAME, POLICY_OWNER, POLICY_NAME, POLICY_TEXT,
       POLICY_COLUMN, PF_SCHEMA, PF_PACKAGE, PF_FUNCTION, ENABLED, SEL, INS,
       UPD, DEL, AUDIT_TRAIL, POLICY_COLUMN_OPTIONS
FROM DBA_AUDIT_POLICIES, ALL_TABLES t
WHERE
(OBJECT_SCHEMA = t.OWNER AND OBJECT_NAME = t.TABLE_NAME)
union
SELECT OBJECT_SCHEMA, OBJECT_NAME, POLICY_OWNER, POLICY_NAME, POLICY_TEXT,
       POLICY_COLUMN, PF_SCHEMA, PF_PACKAGE, PF_FUNCTION, ENABLED, SEL, INS,
       UPD, DEL, AUDIT_TRAIL, POLICY_COLUMN_OPTIONS
FROM DBA_AUDIT_POLICIES, ALL_VIEWS v
WHERE
(OBJECT_SCHEMA = v.OWNER AND OBJECT_NAME = v.VIEW_NAME)

View Text - HTML Formatted

SELECT OBJECT_SCHEMA
, OBJECT_NAME
, POLICY_OWNER
, POLICY_NAME
, POLICY_TEXT
, POLICY_COLUMN
, PF_SCHEMA
, PF_PACKAGE
, PF_FUNCTION
, ENABLED
, SEL
, INS
, UPD
, DEL
, AUDIT_TRAIL
, POLICY_COLUMN_OPTIONS FROM DBA_AUDIT_POLICIES
, ALL_TABLES T WHERE (OBJECT_SCHEMA = T.OWNER
AND OBJECT_NAME = T.TABLE_NAME) UNION SELECT OBJECT_SCHEMA
, OBJECT_NAME
, POLICY_OWNER
, POLICY_NAME
, POLICY_TEXT
, POLICY_COLUMN
, PF_SCHEMA
, PF_PACKAGE
, PF_FUNCTION
, ENABLED
, SEL
, INS
, UPD
, DEL
, AUDIT_TRAIL
, POLICY_COLUMN_OPTIONS FROM DBA_AUDIT_POLICIES
, ALL_VIEWS V WHERE (OBJECT_SCHEMA = V.OWNER
AND OBJECT_NAME = V.VIEW_NAME)