Multiple choice technology databases

Which of the following statement will NOT allow db2user to grant the privileges specified in the statement to others?

  1. GRANT INDEX ON employee TO db2user WITH GRANT OPTION

  2. GRANT UPDATE (salary, bonus) ON employee TO PUBLIC WITH GRANT

  3. GRANT CONTROL ON employee TO PUBLIC WITH GRANT OPTION

  4. GRANT ALTERIN, CREATEIN, DROPIN ON schema1 TO db2user WITH GRANT
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The CONTROL privilege cannot be granted WITH GRANT OPTION in DB2. CONTROL is an ownership-level privilege that inherently includes grant authority but cannot explicitly use WITH GRANT OPTION syntax. When you grant CONTROL to PUBLIC, recipients get full control but you cannot specify WITH GRANT OPTION for CONTROL itself. The other options are valid: INDEX and UPDATE privileges can have GRANT OPTION, and schema privileges (ALTERIN, CREATEIN, DROPIN) can use WITH GRANT.

Keep practicing — related questions