Multiple choice

Which of the following packages should be used to grant resource groups to users?

  1. DBMS_REPCAT_AUTH

  2. DBMS_REPCAT_ADMIN

  3. DBMS_RESOURCE_MANAGER

  4. DBMS_RESOURCE_MANAGER_PRIVS
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

DBMS_RESOURCE_MANAGER_PRIVS is the Oracle package specifically designed for granting and revoking resource manager privileges to users and roles. It contains procedures like GRANT_SYSTEM_PRIVILEGE and REVOKE_SYSTEM_PRIVILEGE for managing resource group access. DBMS_REPCAT_AUTH and DBMS_REPCAT_ADMIN are for replication management. DBMS_RESOURCE_MANAGER is the main package for creating and managing resource plans and consumer groups, not for granting privileges.

Keep practicing — related questions