试题详情
单项选择题 You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this?（）

A、GRANT select, insert, update   ON student_grades   TO manager;

B、GRANT select, insert, update   ON student_grades   TO ROLE manager;

C、GRANT select, insert, modify   ON student_grades   TO manager   WITH GRANT OPTION;

D、GRANT select, insert, update   ON student_grades   TO manager   WITH GRANT OPTION;

E、GRANT select, insert, update   ON student_grades   TO ROLE manager   WITH GRANT OPTION;

F、GRANT select, insert, modify   ON student_grades   TO ROLE manager   WITH GRANT OPTION;

  • 关注下方微信公众号，在线模考后查看

热门试题