VIEW: SYS.USER_RSRC_MANAGER_SYSTEM_PRIVS

Source

View Text - Preformatted

select spm.name,decode(min(bitand(nvl(sa.option$,0),17)),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 and sa.grantee# = userenv('SCHEMAID')
group by spm.name

View Text - HTML Formatted

SELECT SPM.NAME
, DECODE(MIN(BITAND(NVL(SA.OPTION$
, 0)
, 17))
, 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
AND SA.GRANTEE# = USERENV('SCHEMAID') GROUP BY SPM.NAME