General |
Purpose |
Maintains Resource Manager privileges |
Source |
$ORACLE_HOME/rdbms/admin/dbmsrmpr.sql |
First Available |
8.1.5 |
Data Dictionary Objects |
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_cpu_mth |
default_consumer_group |
|
|
Security Model |
Execute is granted to PUBLIC |
|
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 |