创建同义词

/*

赋表

dep009.t_bd_bank

dep009.t_cus_openbankser

dep009.t_cus_cityser

dep009.t_cus_provinceser

权限给用户finwbsuser

*/

grant insert,delete,select,update on dep009.t_bd_bank to finwbsuser;

grant insert,delete,select,update on dep009.t_cus_openbankser to finwbsuser;

grant insert,delete,select,update on dep009.t_cus_cityser to finwbsuser;

grant insert,delete,select,update on dep009.t_cus_provinceser to finwbsuser; 

/*

创建同义词

*/

create synonym finwbsuser.t_bd_bank for dep009.t_bd_bank ;

create synonym finwbsuser.t_cus_openbankser for dep009.t_cus_openbankser;

create synonym finwbsuser.t_cus_cityser for dep009.t_cus_cityser ;

create synonym finwbsuser.t_cus_provinceser for dep009.t_cus_provinceser;