ITPub博客

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

042-148

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-15 15:53:01 0 删除 编辑
148. The HR user creates a view with this command:
SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp;
Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario?
A) HR can grant the privilege to JIM but without GRANT OPTION.
B) HR can grant the privilege to JIM because HR is the owner of the view.
C) SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
D) HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.
答案:D
HR用户根据scott用户的emp表建立了一个视图,他想把该视图的select权限赋予JIM用户,他需要有emp表的with GRANT OPTION才能这么做
缺省不能传递权限,要想能 Sys用户: grant create table to test1 with admin option;
而后test1授于test2了,然后收回test1,则test2的系统权限还在,对象权限则收回了
test1:grant all on t to test2 with grant option; 对象权限是 grant option
只有角色的赋予才像C选项这样做

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718653/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    202916