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 managerB. GRANT select, insert, update ON student_grades TO ROLE managerC. 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;

单项选择题

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