106. 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 succeeds and privileges are revoked from JIM.

B) The command fails because SCOTT still has privileges with him.

C) The command fails because HR cannot revoke the privileges from JIM.

D) Only HR can perform. SELECT, INSERT, and UPDATE operations on the EMP table.

答案:C

A、B、C三个用户，A用户把自己表的权限赋给了B、B又赋给了C，这时侯A用户是不能直接revoke C用户关于该表的权限。

授予他人的对象权限在被授予者向第三人授予该权限时，最初授权者无法取消第三人的对象权限。但是如果最初授予的是系统权限，则最初授权人可以取消第三人的系统权限。

ITPub博客

042-106