试题详情
- 单项选择题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
关注下方微信公众号,在线模考后查看
热门试题