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博客

042-148