oracle中创建用户,指定要查询的视图 --九五小庞
--01: 创建PACS用户,并且初始密码为PACS
create user PACS identified by "PACS";
--02: 赋予该用户登录数据库的权限.
grant create session to PACS;
--03: 赋予该用户查看RIS下的视图V_HIS_RESULT的权限.
grant select on RIS.V_HIS_RESULT to PACS;
--04:创建同义词,新创建的用户在查询数据库的时候,不需要带库名(select *from V_HIS_RESULT )
create public synonym V_HIS_RESULT for ris.V_HIS_RESULT
原文链接:https://blog.csdn.net/inter_peng/article/details/79462153