Multiple choice technology databases

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.
Reveal answer Fill a bubble to check yourself
B,E Correct answer
Explanation

The WITH GRANT OPTION clause allows the grantee (MANAGER) to both exercise the granted privileges (SELECT, INSERT, UPDATE on STUDENT_GRADES) and grant those same privileges to other users. Option B correctly describes the GRANT OPTION aspect, while option E correctly describes the privileges granted. MANAGER can be either a user or a role.

Keep practicing — related questions