🎴 Flashcard Mode
Oracle Database Administration & SQL Fundamentals
Card1 / 21
Mastered0
Review0
QuestionClick to flip
Which of the following packages should be used to grant resource groups to users?
AnswerClick to flip back
A
DBMS_RESOURCE_MANAGER_PRIVS
💡 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.