Oracle DBMS_RESOURCE_MANAGER_PRIVS
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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