VIEW: SYS.DBA_PRIV_AUDIT_OPTS

Source

View Text - Preformatted

select decode(aud.user#, 0 /* client operations through proxy */, 'ANY CLIENT',
                         1 /* System wide auditing*/, null,
                         client.name) /* USER_NAME */,
       proxy.name       /* PROXY_NAME */,
       prv.name         /* PRIVILEGE */,
       decode(aud.success, 1, 'BY SESSION', 2, 'BY ACCESS', 'NOT SET')
                        /* SUCCESS */,
       decode(aud.failure, 1, 'BY SESSION', 2, 'BY ACCESS', 'NOT SET')
                        /* FAILURE */
from sys.user$ client, sys.user$ proxy, system_privilege_map prv,
     sys.audit$ aud
where aud.option# = -prv.privilege
  and aud.user# = client.user#
  and aud.proxy# = proxy.user#(+)

View Text - HTML Formatted

SELECT DECODE(AUD.USER#
, 0 /* CLIENT OPERATIONS THROUGH PROXY */
, 'ANY CLIENT'
, 1 /* SYSTEM WIDE AUDITING*/
, NULL
, CLIENT.NAME) /* USER_NAME */
, PROXY.NAME /* PROXY_NAME */
, PRV.NAME /* PRIVILEGE */
, DECODE(AUD.SUCCESS
, 1
, 'BY SESSION'
, 2
, 'BY ACCESS'
, 'NOT SET') /* SUCCESS */
, DECODE(AUD.FAILURE
, 1
, 'BY SESSION'
, 2
, 'BY ACCESS'
, 'NOT SET') /* FAILURE */ FROM SYS.USER$ CLIENT
, SYS.USER$ PROXY
, SYSTEM_PRIVILEGE_MAP PRV
, SYS.AUDIT$ AUD WHERE AUD.OPTION# = -PRV.PRIVILEGE
AND AUD.USER# = CLIENT.USER#
AND AUD.PROXY# = PROXY.USER#(+)