GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;

  1. MANAGER must be a role.

  2. It allows the MANAGER to pass the specified privileges on to other users.

  3. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.

  4. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.

  5. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.

  6. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.


Correct Option: B,E

Find more quizzes: