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
答案解析:有
微信扫一扫手机做题