用户A创建视图如下
create or replace view v_vessel_shipper as
select bb.*,aa.username,aa.useralias from 用户B.tran_vessel bb,(
select substr(a.dest,3,(length(a.dest)-2)) codevessel,a.*,b.* from edi_dispatch a,edi_user b where
a.newdest=b.username and a.msgtype='INHOUSE_PRLOAD') aa
where bb.codevessel_xdf=aa.codevessel(+)

当在用户A下执行
grant select on v_vessel_shipper to 用户C;
报错ORA-01720: grant option does not exist for '用户B.TRAN_VESSEL'
解决办法
用户B下
grant select/all on tran_vessel to xib with grant option;