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
正确答案:E
答案解析:有

微信扫一扫手机做题