VIEW: SYS.SM$AUDIT_CONFIG

Source

View Text - Preformatted

select 'Object', owner, object_type || ' ' || object_name
    from sys.dba_obj_audit_opts
    where ALT != '-/-' OR AUD != '-/-' OR COM != '-/-' OR DEL != '-/-'
       OR GRA != '-/-' OR IND != '-/-' OR INS != '-/-' OR LOC != '-/-'
       OR REN != '-/-' OR SEL != '-/-' OR UPD != '-/-' OR FBK != '-/-'
       OR EXE != '-/-'
    union all select 'Privilege', user_name, privilege
    from sys.dba_priv_audit_opts
    union all select 'Statement', user_name, audit_option
    from sys.dba_stmt_audit_opts

View Text - HTML Formatted

SELECT 'OBJECT'
, OWNER
, OBJECT_TYPE || ' ' || OBJECT_NAME
FROM SYS.DBA_OBJ_AUDIT_OPTS
WHERE ALT != '-/-' OR AUD != '-/-' OR COM != '-/-' OR DEL != '-/-' OR GRA != '-/-' OR IND != '-/-' OR INS != '-/-' OR LOC != '-/-' OR REN != '-/-' OR SEL != '-/-' OR UPD != '-/-' OR FBK != '-/-' OR EXE != '-/-' UNION ALL SELECT 'PRIVILEGE'
, USER_NAME
, PRIVILEGE
FROM SYS.DBA_PRIV_AUDIT_OPTS UNION ALL SELECT 'STATEMENT'
, USER_NAME
, AUDIT_OPTION
FROM SYS.DBA_STMT_AUDIT_OPTS