Oracle | DBMS_RESOURCE_MANAGER

Oracle DBMS_RESOURCE_MANAGER_PRIVS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Maintainance of Resource Manager privileges

AUTHID CURRENT_USER

Dependencies

DBMS_AQADM	DBMS_RMIN_SYS	DBMS_TEQK
DBMS_RMIN	DBMS_SYS_ERROR

Documented Yes: Packages and Types Reference

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	REVOKE_SWITCH_CONSUMER_GROUP
GRANT_SYSTEM_PRIVILEGE	REVOKE_SYSTEM_PRIVILEGE
GRANT_SYSTEM_PRIVILEGE

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);

BEGIN

        dbms_resource_manager_privs.grant_switch_consumer_group(''.'',FALSE);

        dbms_resoure_manager.set_initial_consumer_group('DBA_PROD', 'PROD_GRP');

      END;

      /

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)