The HR user owns the BONUSES table. HR grants privileges to the user TOM by using the command:
SQL> GRANT SELECT ON bonuses TO tom WITH GRANT OPTION;
TOM then executes this command to grant privileges to the user JIM:
SQL> GRANT SELET ON hr.bonuses TO jim;
Which statement is true?
A.
TOM cannot revoke the SELECT ON HR.BONUSES privilege from JIM.
B.
HR can revoke the SELECT ON HR.BINUSES privilege from JIM.
C.
JIM can grant the SELECT ON HR.BONUSES privilege to other users, but cannot revoke the privilege from
them.
D.
HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the
SELECT ON HR.BONUSES privilege from JIM.
The correct answer should be D.
D