DROP public synonym marketmonitor_day;

DROP public synonym marketmonitor_month;

DROP public synonym marketmonitor_week;

create public synonym MARKETMONITOR_DAY for userdata.MARKETMONITOR_DAY;

create public synonym MARKETMONITOR_MONTH for userdata.MARKETMONITOR_MONTH;

create public synonym MARKETMONITOR_WEEK for userdata.MARKETMONITOR_WEEK;

grant select, insert, delete,update,alter on userdata.marketmonitor_day to useropr;

grant select, insert, delete,update,alter on userdata.marketmonitor_month to useropr;

grant select, insert, delete,update,alter on userdata.marketmonitor_week to useropr;