December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE
(grantee_name IN VARCHAR2,
privilege_name IN VARCHAR2 DEFAULT 'ADMINISTER_RESOURCE_MANAGER',
admin_option IN BOOLEAN);
Grants privilege_name to grantee_name. If admin_option, grantee_name can regrant privilege.
PROCEDURE DBMS_RESOURCE_MANAGER_PRIVS.REVOKE_SYSTEM_PRIVILEGE
(grantee_name IN VARCHAR2,
privilege_name IN VARCHAR2 DEFAULT 'ADMINISTER_RESOURCE_MANAGER');
Revokes privilege_name from grantee_name.
PROCEDURE DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP
(grantee_name IN VARCHAR2,
consumer_group IN VARCHAR2,
grant_option IN BOOLEAN);
Grants grantee_name the ability to switch to consumer_group. If grant_option, grantee_name can regrant access.
PROCEDURE DBMS_RESOURCE_MANAGER_PRIVS.REVOKE_SWITCH_CONSUMER_GROUP
(grantee_name IN VARCHAR2,
consumer_group IN VARCHAR2);
Revokes grantee_name the ability to switch to consumer_group.