可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You need to give the MANAGER role the


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;
  • FGRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION
参考答案
参考解析:
分类:1Z0-007题库