What does adding WITH GRANT OPTION to GRANT SELECT ON Emp TO sara allow sara to do?
Correct answer B. Grant SELECT on Emp to other users
Explanation
WITH GRANT OPTION lets the recipient pass on the same privilege she received, here SELECT on Emp, to other users. It does not add new privileges: sara still cannot update rows or drop the table, because those need UPDATE privilege or ownership. Revoking the privilege from sara later may require CASCADE, since others depend on her grant.
Answer checked How we write and check questions
Discussion