多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题