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.
正确答案:C
答案解析:有
微信扫一扫手机做题