Oracle DBMS_RESOURCE_MANAGER_PRIVS
Version 19.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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 18c
What's New In 19c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx