--赋予权限的时候加上WITH GRANT OPTION--测试过程 Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0 Connected as redlight SQL> conn redlight/kkk; Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0 Connected as redlightSQL> create table table3( cid int );Table createdSQL> insert into table3 values(1);1 row insertedSQL> create or replace view view_t3 as select * from table3;View createdSQL> grant select on view_t3 to system WITH GRANT OPTION;Grant succeededSQL> conn system/lidexian; Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0 Connected as systemSQL> create or replace view v_t3 as select * from redlight.view_t3;View createdSQL> select * from v_t3; CID --------------------------------------- 1
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as redlight
SQL> conn redlight/kkk;
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as redlightSQL> create table table3( cid int );Table createdSQL> insert into table3 values(1);1 row insertedSQL> create or replace view view_t3 as select * from table3;View createdSQL> grant select on view_t3 to system WITH GRANT OPTION;Grant succeededSQL> conn system/lidexian;
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as systemSQL> create or replace view v_t3 as select * from redlight.view_t3;View createdSQL> select * from v_t3; CID
---------------------------------------
1