Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_RESOURCE_MANAGER_PRIVS, 3 of 5
This procedure performs a revoke of a system privilege from a user or role.
DBMS_RESOURCE_MANAGER_PRIVS.REVOKE_SYSTEM_PRIVILEGE ( revokee_name IN VARCHAR2, privilege_name IN VARCHAR2 DEFAULT 'ADMINISTER_RESOURCE_MANAGER');
Parameter | Description |
---|---|
revokee_name |
Name of the user or role from whom privilege is to be revoked. |
privilege_name |
Name of the privilege to be revoked. |
The following call revokes the ADMINISTER_RESOURCE_MANAGER
from user scott:
DBMS_RESOURCE_MANAGER_PRIVS.REVOKE_SYSTEM_PRIVILEGE ('scott');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|