DBA_RSRC_CONSUMER_GROUP_PRIVS

DBA_RSRC_CONSUMER_GROUP_PRIVS lists all resource consumer groups and the users and roles assigned to them. The grant referred to in this view and the related view is the grant of the SWITCH_CONSUMER_GROUP object privilege, which is granted using the DBMS_RESOURCE_MANAGER_PRIVS package. (This privilege is not granted through the GRANT SQL statement.)

Related View

• USER_RSRC_CONSUMER_GROUP_PRIVS lists all resource consumer groups to which the current user is assigned. This view does not display the GRANTEE column.

  Column	Datatype	NULL	Description
  GRANTEE	VARCHAR2(30)	NOT NULL	User or role receiving the grant
  GRANTED_GROUP	VARCHAR2(30)		Granted consumer group name
  GRANT_OPTION	VARCHAR2(3)		(YES/NO) Indicates whether grant was with the GRANT option
  INITIAL_GROUP	VARCHAR2(3)		(YES/NO) Indicates whether consumer group is designated as the default for this user or role

  See Also: Oracle9i Supplied PL/SQL Packages and Types Reference for more information on consumer group privileges