CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

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
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [42 users online]    © 2010 psoug.org