VIEW: SYS.DBA_RSRC_MANAGER_SYSTEM_PRIVS

Source

View Text - Preformatted

select u.name,spm.name,decode(min(bitand(sa.option$, 17)),null,'NO',0,'NO','YES')
from sys.user$ u, system_privilege_map spm, sys.sysauth$ sa
where sa.grantee# = u.user# and sa.privilege# = spm.privilege
and sa.privilege# = -227 group by u.name, spm.name

View Text - HTML Formatted

SELECT U.NAME
, SPM.NAME
, DECODE(MIN(BITAND(SA.OPTION$
, 17))
, NULL
, 'NO'
, 0
, 'NO'
, 'YES') FROM SYS.USER$ U
, SYSTEM_PRIVILEGE_MAP SPM
, SYS.SYSAUTH$ SA WHERE SA.GRANTEE# = U.USER#
AND SA.PRIVILEGE# = SPM.PRIVILEGE AND SA.PRIVILEGE# = -227 GROUP BY U.NAME
, SPM.NAME