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