Oracle DBMS_RESOURCE_MANAGER_PRIVS
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.
Purpose Maintainance of Resource Manager privileges
AUTHID CURRENT_USER
Dependencies
DBMS_RMIN DBMS_SYS_ERROR  
Documented Yes
First Available 8.1.5
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source $ORACLE_HOME/rdbms/admin/dbmsrmpr.sql
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 (Link Page Bottom)
 
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 (Link Page Bottom)
 
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 (Link Page Bottom)

Related Topics
Built-in Functions
Built-in Packages
DBMS_RESOURCE_MANAGER
DBMS_RMGR_PACT_EXPORT
Profiles
Roles
System Privileges
Users
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved