---

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（）
A:The command fails because SCOTT still has privileges.
B:The command succeeds and privileges are revoked from JIM.
C:The command fails because HR cannot revoke the privileges from JIM.
D:The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.

---

出自：Oracle认证

显示答案