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

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

微信扫一扫手机做题