Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_RESOURCE_MANAGER_PRIVS, 4 of 5
This procedure grants the privilege to switch to a resource consumer group.
DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP ( grantee_name IN VARCHAR2, consumer_group IN VARCHAR2, grant_option IN BOOLEAN);
If you grant permission to switch to a particular consumer group to a user, then that user can immediately switch their current consumer group to the new consumer group.
If you grant permission to switch to a particular consumer group to a role, then any users who have been granted that role and have enabled that role can immediately switch their current consumer group to the new consumer group.
If you grant permission to switch to a particular consumer group to PUBLIC
, then any user can switch to that consumer group.
If the grant_option
parameter is TRUE
, then users granted switch privilege for the consumer group may also grant switch privileges for that consumer group to others.
In order to set the initial consumer group of a user, you must grant the switch privilege for that group to the user.
DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_COMSUMER_GROUP ( 'scott', 'mail_maintenance_group', true); DBMS_RESOURCE_MANAGER.SET_INITIAL_CONSUMER_GROUP ( 'scott', 'mail_maintenance_group');
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|