What happens if you drop USER B from the HANA database?

USER A grants a privilege to USER B, and USER B grants the same to USER C afterwards.

What happens if you drop USER B from the HANA database?

A. The privilege remains assigned to both USER A and USER C.

B. The privilege is revoked from USER A, but not USER C.

C. The privilege is revoked from both USER A and USER C.

D. The privilege is revoked from USER C, but not USER A.

Answer: D