Exam 1z0-071 topic 1 question 123 discussion

When I tested this one, BD were true and E returned grant succeeded. However when I tested to see if those table privileges had actually been granted by E, the recipient had none of those abilities.

A, D A. User FIN_CLERK can grant SELECT on SCOTT.EMP to user FIN_MANAGER - This is true because user FINANCE has been granted SELECT privilege on SCOTT.EMP with the GRANT OPTION, and user FINANCE subsequently granted SELECT on SCOTT.EMP to user FIN_CLERK. The GRANT OPTION allows the privilege to be further granted to other users. D. Revoking SELECT on SCOTT.EMP from user FINANCE will also revoke the privilege from user FIN_CLERK - This is true because when a privilege is revoked from a user who was granted the privilege with the GRANT OPTION, and who subsequently granted that privilege to other users, then the privilege is also revoked from the other users.

BDE. B is right, because dropping a user implies to REVOKE all OBJECT PRIVILEGES granted by this user. Pay attention in the difference between object privileges and system privileges. System privileges must be revoked directly from user who has them.

This is from official Oracle course: "If a user leaves the company and you revoke his or her privileges, you must re-grant any privileges that this user granted to other users. If you drop the user account without revoking privileges from it, the system privileges granted by this user to other users are not affected by this action."

why E is not correct?