You need to give the MANAGER role the ability to select

单项选择题

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;

1Z0-007