Oracle | DBMS_RESOURCE_MANAGER

Oracle DBMS_RESOURCE_MANAGER_PRIVS Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Maintainance of Resource Manager privileges

AUTHID CURRENT_USER

Dependencies

DBMS_RMIN

DBMS_RMIN_SYS

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