Oracle 达人请进，关于创建视图的问题......

Question

create or replace view smartemr.zyxx as
select "ZHUYH","XINGM","XINGB","CHUSNY","HUNYZK","WENHCD","ZHIY","CHUSDS","CHUSDX","MINZ","GUOJ","SHENFZ","DANWDZ","DANWDH","DANWYB","HUKDZ","HUKYB","LXRXM","LXRGX","LXRDH","RUYTJ","RUYKB","RUYSJ","RUYBQ","MENZYS","MENZZD","RUYZD","QUEZSJ","YAJ","DANBR","RUKSJ","HULDJ","ZHUZYS","CHUYSJ","CHUYBQ","CHUYJZ","BANLRQ","CAOZY","ZHUANGT","LSH","YOUHFS","YOUHFSMC","ISGZ","JIFRQ","YAJZT","CHUSRQ","XINGMPYM","BINGRLX","BIGNRBQ","ISYZ","FABJJ","GUOMYW","FH","CH","YONGYQK","XIANGGJC" from smartmed2.zyxx;

执行以上创建视图的语句，提示“权限不足”，授予用户 Smartemr DBA 以及 Create View 两个权限结果仍然失败......

经测试，在同一用户内创建视图不会有问题，但是我这个数据库是从 817 移植过来的，不想改程序，所以只能使用这种跨用户创建视图的方式（在 817 中创建是成功的......到 10g 就不行了），这个能不能解决呢？？？？

Answer 1

你不是没有权限创建视图，你是没有权限在smartemr用户下访问smartmed2用户的zyxx（表或视图）。需要通过zyxx用户或者更高权限的用户为smartemr授予select的zyxx权限

Answer 2

授予Smartemr 用户DBA权限是没有用的，要给你现在登入的用户授予权限才对。

Answer 3

赋予查询smartmed2.zyxx 这个表的权限吧？你单独查询看能查到不。