| General Information |
| Purpose |
Maintains Resource Manager privileges |
| Source |
$ORACLE_HOME/rdbms/admin/dbmsrmpr.sql |
| First Available |
8.1.5 |
| Dependencies |
| DBA_RSRC_CONSUMER_GROUPS |
GV_$RSRC_CONSUMER_GROUP |
| DBA_RSRC_CONSUMER_GROUP_PRIVS |
RESOURCE_CONSUMER_GROUP$ |
| DBA_RSRC_PLANS |
RESOURCE_PLAN$ |
| DBMS_RMIN |
RESOURCE_PLAN_DIRECTIVE$ |
| DBMS_SYS_ERROR |
V$RSRC_CONSUMER_GROUP_CUP_MTH |
| DEFAULT_CONSUMER_GROUP |
|
|
| Security Model |
Execute is granted to PUBLIC |
| Subprograms |
|
| |
| GRANT_SWITCH_CONSUMER_GROUP |
| Grants permission to a user, role, or PUBLIC to switch to a specified consumer group |
dbms_resource_manager_privs.grant_switch_consumer_group(
grantee_name IN VARCHAR2,
consumer_group IN VARCHAR2,
grant_option IN BOOLEAN); |
| See DBMS_RESOURCE_MANAGER Demo |
| |
| GRANT_SYSTEM_PRIVILEGE |
| Grants the ADMINISTER_RESOURCE_MANAGER 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); |
| See DBMS_RESOURCE_MANAGER Demo |
| |
| REVOKE_SWITCH_CONSUMER_GROUP |
| Revokes permission for a user, role, or PUBLIC to switch to a specified resource consumer group |
dbms_resource_manager_privs.revoke_switch_consumer_group(
revokee_name IN VARCHAR2,
consumer_group IN VARCHAR2); |
BEGIN
dbms_resource_manager_privs.revoke_switch_consumer_group(
'UWCLASS', 'rpt_writers_grp');
END;
/ |
| |
| REVOKE_SYSTEM_PRIVILEGE |
| Revokes the ADMINISTER_RESOURCE _MANAGER 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'); |
| See DBMS_RESOURCE_MANAGER Demo |
