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?
Question:
Which statement is true?
Options:
TOM cannot revoke the SELECT ON HR. BONUSES privilege from JIM.
HR can revoke the SELECT ON HR.BINUSES privilege from JIM.
JIM can grant the SELECT ON HR. BONUSES privilege to other users, but cannot revoke the privilege from them.
HR can revoke the SELECT ON HR. BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM
Correct Answer
The Correct Answer for this Question is
HR can revoke the SELECT ON HR. BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM
