view 的 privilege

SQL> create or replace view splexadmin.v2 as select * from scott.emp;

View created.

SQL> grant select on splexadmin.v2 to u1;

Grant succeeded.

SQL> grant select on scott.emp     to u1;

Grant succeeded.

SQL> conn u1/u1
Connected.
SQL> select count(*) from splexadmin.v2;
select count(*) from splexadmin.v2
                                *
ERROR at line 1:
ORA-01031: insufficient privileges

如图， 检查步骤感觉没有错的，但是总是有权限错误。 后来发现需要做如下操作。

SQL> grant all on citosadmin.cntr to splexadmin with grant option;
SQL> grant all on citosadmin.CNTR_INSTRUCTION_DERIVE to splexadmin with grant option;

因为， u1在查询视图的时候，是通过splexadmin来访问scott.emp的。  splexadmin需要能够把对scott.emp的访问传递给u1