Practice mode DBMS and SQL

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.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.