VIEW: SYS.KU$_AUDIT_VIEW

Source

View Text - Preformatted

select '1','0',
        a.user#,
        u.name,
        a.proxy#,
        m.name, m.property,
        NVL(a.success, 0),
        NVL(a.failure, 0),
        a.option#
  from     sys.audit$ a, sys.stmt_audit_option_map m,
           sys.user$ u
  where    a.user# = u.user# and
           a.option# = m.option#
         AND (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0
                OR EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, A.USER#
, U.NAME
, A.PROXY#
, M.NAME
, M.PROPERTY
, NVL(A.SUCCESS
, 0)
, NVL(A.FAILURE
, 0)
, A.OPTION#
FROM SYS.AUDIT$ A
, SYS.STMT_AUDIT_OPTION_MAP M
, SYS.USER$ U
WHERE A.USER# = U.USER# AND A.OPTION# = M.OPTION#
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))