VIEW: SYS.USER_RSRC_CONSUMER_GROUP_PRIVS

Source

View Text - Preformatted

select g.name, decode(bitand(nvl(o.option$, 0),17),0,'NO','YES'),
       decode(nvl(cgm.consumer_group, 'DEFAULT_CONSUMER_GROUP'),
              g.name, 'YES', 'NO')
from sys.user$ u left outer join sys.resource_group_mapping$ cgm on
     (cgm.attribute = 'ORACLE_USER' and cgm.status = 'ACTIVE' and
      cgm.value = u.name), sys.resource_consumer_group$ g, sys.objauth$ o
where o.obj# = g.obj# and o.grantee# = u.user#
and o.grantee# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT G.NAME
, DECODE(BITAND(NVL(O.OPTION$
, 0)
, 17)
, 0
, 'NO'
, 'YES')
, DECODE(NVL(CGM.CONSUMER_GROUP
, 'DEFAULT_CONSUMER_GROUP')
, G.NAME
, 'YES'
, 'NO') FROM SYS.USER$ U LEFT OUTER JOIN SYS.RESOURCE_GROUP_MAPPING$ CGM ON (CGM.ATTRIBUTE = 'ORACLE_USER'
AND CGM.STATUS = 'ACTIVE' AND CGM.VALUE = U.NAME)
, SYS.RESOURCE_CONSUMER_GROUP$ G
, SYS.OBJAUTH$ O WHERE O.OBJ# = G.OBJ#
AND O.GRANTEE# = U.USER# AND O.GRANTEE# = USERENV('SCHEMAID')