You want to enable the user, Scott, to change to the GRP1 consumer group by issuing the following code: SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP (’SCOTT’, ’GRP1’, FALSE); How will you grant the switch privilege to the user, Scott?()
- A by using the DBMS_SESSION package
- B by granting the DBA role
- C by using the DBMS_RESOURCE_MANAGER package
- D by using the DBMS_RESOURCE_MANAGER_PRIVS package