Multiple choice technology databases

User system granted SELECT on sh.products to user A using WITH GRANT OPTION. A then granted SELECT on sh.products to user B. A has left the company, and his account is dropped. What happens to B’s privileges on sh.products?

  1. B loses his SELECT privilege on sh.products.

  2. B retains his SELECT privilege on sh.products.

  3. B loses his SELECT privilege if A was dropped with the CASCADE REVOKE option.

  4. B retains his SELECT privilege if A was dropped with the NOCASCADE REVOKE option
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When a user who granted object privileges WITH GRANT OPTION is dropped, all privileges they granted are automatically revoked from grantees. B's privilege on sh.products was granted by A, so it's lost when A is dropped.

AI explanation

To answer this question, we need to understand how privileges and the "WITH GRANT OPTION" work in Oracle.

When user A is granted SELECT privilege on sh.products with the "WITH GRANT OPTION," it means that A can also grant this privilege to other users. In this case, A grants SELECT privilege on sh.products to user B.

However, when user A's account is dropped, all the privileges granted by A are also revoked. This means that user B will lose the SELECT privilege on sh.products because it was originally granted by user A. Therefore, the correct answer is A: B loses his SELECT privilege on sh.products.

Keep practicing — related questions