You want to create a consumer group, GROUP1, and you execute the following command in
the command-line interface:
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP
(CONSUMER_GROUP
=>’group1′, COMMENT => ‘New Group’); This command errorsout displaying the following
message:
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at “SYS.DBMS_RMIN”, line 115
ORA-06512: at SYS.DBMS_RESOURCE_MANAGER”, line 108 ORA-06512: at line 1
What action would you take to overcome this error?
A.
grant SYSDBA to the user
B.
grant SYSOPER to the user
C.
grant the RESOURCE role to the user
D.
use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege
to the use
E.
grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the
DBMS_RESOURCE_MANAGER_PRIVS package