You want to create a consumer group, GROUP1, and you execute the following command in the command/x7fline interface: SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =>’group1’, COMMENT => ’New Group’); This command errors out displaying the following message: ERROR at line 1: ORA/x7f01031: insufficient privileges ORA/x7f06512: at "SYS.DBMS_RMIN", line 115 ORA/x7f06512: at SYS.DBMS_RESOURCE_MANAGER", line 108 ORA/x7f06512: 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 user
- E、grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package
正确答案:E
答案解析:有
微信扫一扫手机做题