$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print << Oracle DBMS_RESOURCE_MANAGER_PRIVS Version 11.1  
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
 
Related Topics
DBMS_RESOURCE_MANAGER
Profiles
Roles
Users
  EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>