create user wtuser identified by wtuser
/
grant connect,resource to xtuser
drop public synonym V_XT_INTF_DEPT
/
drop public synonym V_XT_INTF_WARD
/
drop public synonym V_XT_PAT_MASTER_INDEX
/
drop public synonym V_XT_INTF_USER
/
drop public synonym BG_PAT_PRESCRIBE
/
drop public synonym V_XT_INTF_BED
/
create public synonym V_XT_INTF_DEPT for ZYYHIS.V_XT_INTF_DEPT
/
create public synonym V_XT_INTF_WARD for ZYYHIS.V_XT_INTF_WARD
/
create public synonym V_XT_PAT_MASTER_INDEX for ZYYHIS.V_XT_PAT_MASTER_INDEX
/
create public synonym V_XT_INTF_USER for ZYYHIS.V_XT_INTF_USER
/
create public synonym BG_PAT_PRESCRIBE for ZYYHIS.BG_PAT_PRESCRIBE
/
create public synonym V_XT_INTF_BED for ZYYHIS.V_XT_INTF_BED
grant select on ZYYHIS.V_XT_INTF_DEPT to xtuser;
/
grant select on ZYYHIS.V_XT_INTF_WARD to xtuser;
/
grant select on ZYYHIS.V_XT_PAT_MASTER_INDEX to xtuser;
/
grant select on ZYYHIS.V_XT_INTF_USER to xtuser;
/
grant select on ZYYHIS.BG_PAT_PRESCRIBE to xtuser;
/
grant select on ZYYHIS.V_XT_INTF_BED to xtuser;
/
