The HR user owns the EMP table. The HR user grants privileges to the SCOTT user by using this
command:
SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION;
The SCOTT user executes this command to grant privileges to the JIM user:
SQL> GRANT SELECT,INSERT,UPDATE ON hr.emp TO jim;
Now the HR user decides to revoke privileges from JIM by using this command:
SQL> REVOKE SELECT,INSERT,UPDATE ON emp FROM jim;
Which statement is true after HR issues the REVOKE command?
A.
The command fails because SCOTT still has privileges with him.
B.
Only HR can perform SELECT, INSERT, and UPDATE operations on the EMP table.
C.
The command fails because HR cannot revoke the privileges from JIM.
D.
The command succeeds and privileges are revoked from JIM.