Administering the Database Resource Manager - Oracle 10g

You must have the system privilege ADMINISTER_RESOURCE_MANAGER to administer the Database Resource Manager. Typically, database administrators have this privilege with the ADMIN option as part of the DBA (or equivalent) role. Being an administrator for the Database Resource Manager lets you execute all of the procedures in the DBMS _RESOURCE _MANAGER package. These are listed in the following table, and their use is explained in succeeding sections of this chapter.

Administering the Database Resource ManagerAdministering the Database Resource ManagerAdministering the Database Resource Manager

You may, as an administrator with the ADMIN option, choose to grant the administrative privilege to other users or roles. This is possible using the DBMS _RESOURCE _MANAGER _PRIVS package. This package contains the procedures listed in the table below.

The following example grants the administrative privilege to user scott, but does not grant scott the ADMIN option. Therefore, scott can execute all of the procedures in the DBMS_RESOURCE_MANAGER package, but scott cannot use the GRANT_SYSTEM_PRIVILEGE procedure to grant the administrative privilege to others.

You can revoke this privilege using the REVOKE _SYSTEM_PRVILEGE procedure.

The other procedures in the DBMS _RESOURCE _MANAGER _PRIVS package are discussed in "Managing the Switch Privilege".


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Oracle 10g Topics