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; /