试题详情
单项选择题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;

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

热门试题