Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_RESOURCE_MANAGER_PRIVS, 2 of 5
This procedure performs a grant of a system privilege to a user or role.
DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE ( grantee_name IN VARCHAR2, privilege_name IN VARCHAR2 DEFAULT 'ADMINISTER_RESOURCE_MANAGER', admin_option IN BOOLEAN);
Currently, Oracle provides only one system privilege for the Resource Manager: ADMINISTER_RESOURCE_MANAGER
. Database administrators have this system privilege with the admin option. The grantee and the revokee can either be a user or a role. Users that have been granted the system privilege with the admin option can also grant this privilege to others.
The following call grants this privilege to a user called scott without the admin option:
DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE ( grantee_name => 'scott', admin_option => FALSE);
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|