The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command: SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION; The user SCOTT executes this command to grant privileges to the user JIM: SQL> GRANT SELECT,INSERT,UPDATE ON hr.emp TO jim; Now, the user HR decides to revoke privileges from JIM using this command: SQL> REVOKE SELECT,INSERT,UPDATE ON emp FROM jim; Which statement is true after HR issues the REVOKE command()
- AThe command fails because SCOTT still has privileges.
- BThe command succeeds and privileges are revoked from JIM.
- CThe command fails because HR cannot revoke the privileges from JIM.
- DThe command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATEoperations on the EMP table.