VIEW: SYS.KU$_RMGR_INIT_CONSUMER_VIEW

Source

View Text - Preformatted

select '1','0',
        ue.user#,
        ue.name, g.name,
        a.option$,
        ue.defschclass
  from sys.user$ ue, sys.resource_consumer_group$ g, sys.objauth$ a,
       sys.dba_rsrc_consumer_group_privs dr
  where a.obj# = g.obj# and a.grantee# = ue.user#
  and   ue.name = dr.grantee
  and   g.name = dr.granted_group
  and   dr.initial_group = 'YES'

View Text - HTML Formatted

SELECT '1'
, '0'
, UE.USER#
, UE.NAME
, G.NAME
, A.OPTION$
, UE.DEFSCHCLASS
FROM SYS.USER$ UE
, SYS.RESOURCE_CONSUMER_GROUP$ G
, SYS.OBJAUTH$ A
, SYS.DBA_RSRC_CONSUMER_GROUP_PRIVS DR
WHERE A.OBJ# = G.OBJ#
AND A.GRANTEE# = UE.USER#
AND UE.NAME = DR.GRANTEE
AND G.NAME = DR.GRANTED_GROUP
AND DR.INITIAL_GROUP = 'YES'