|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
Part Number A89852-02
DBMS_RESOURCE_MANAGER_PRIVS, 5 of 5
This procedure revokes the privilege to switch to a resource consumer group.
DBMS_RESOURCE_MANAGER_PRIVS.REVOKE_SWITCH_CONSUMER_GROUP ( revokee_name IN VARCHAR2, consumer_group IN VARCHAR2);
Name of user/role from which to revoke access.
Name of consumer group.
If you revoke a user's switch privilege for a particular consumer group, then any subsequent attempts by that user to switch to that consumer group will fail.
If you revoke the initial consumer group from a user, then that user will automatically be part of the
DEFAULT_CONSUMER_GROUP consumer group when logging in.
If you revoke the switch privilege for a consumer group from a role, then any users who only had switch privilege for the consumer group via that role will not be subsequently able to switch to that consumer group.
If you revoke the switch privilege for a consumer group from
PUBLIC, then any users who could previously only use the consumer group via
PUBLIC will not be subsequently able to switch to that consumer group.
The following example revokes the privileges to switch to
mail_maintenance_group from Scott: