ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 042-106

042-106

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-15 10:01:34 0 删除 编辑
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博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718609/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 042-105
下一篇: 042-108
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203054