--ccis
Grant select on cascontract to reportportal;
Grant select on customercompanyto reportportal;
Grant select on customeraccountsales to reportportal;
Grant select on sales to reportportal;
Grant select on listedlocation to reportportal;
--Run by user a/c reportportal :
Create synonym cascontract for ccis.cascontract ;
Create synonym customercompanyto for ccis.customercompanyto ;
Create synonym customeraccountsales for ccis.customeraccountsales ;
Create synonym sales for ccis.sales ;
Create synonym listedlocation for ccis.listedlocation ;
其中ccis是数据库名;cascontract 是表名;reportportal 是数据库名;