DBA Data[Home] [Help]

VIEW: SYS.USER_AUDIT_POLICY_COLUMNS

Source

View Text - Preformatted

select OBJECT_SCHEMA, OBJECT_NAME,
       POLICY_NAME, POLICY_COLUMN
from DBA_AUDIT_POLICY_COLUMNS
WHERE OBJECT_SCHEMA = SYS_CONTEXT('USERENV','CURRENT_USER')
View Text - HTML Formatted

SELECT OBJECT_SCHEMA
, OBJECT_NAME
, POLICY_NAME
, POLICY_COLUMN FROM DBA_AUDIT_POLICY_COLUMNS WHERE OBJECT_SCHEMA = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')