Oracle | DBMS_RESOURCE_MANAGER

Oracle DBMS_RESOURCE_MANAGER_PRIVS Version 21c

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