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);
Parameter | Description |
---|---|
revokee_name |
Name of user/role from which to revoke access. |
consumer_group |
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:
DBMS_RESOURCE_MANAGER_PRIVS.REVOKE_SWITCH_CONSUMER_GROUP ( 'scott', 'mail_maintenance_group');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|