| 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 |
