1.给用户scott授权
grant all on orcl to scott;
2.有同义词时,必须给要用到的表授权
grant select,insert,update on scott.V_EA_DICT_INFO to public;
grant select,insert,update on fsm.smp_res_dicts to scott with grant option;
grant select,insert,update on fsm.smp_res_dictitems to scott with grant option;
grant insert on scott.V_EA_DICT_INFO to scott with grant option;
grant insert on scott.V_EA_DICT_INFO to fsm;
Insert into scott.V_EA_DICT_INFO (DICT_ID,DICT_CODE,DICT_NAME,DISPLAY_ORDER,ITEM_CODE,ITEM_NAME,REMARK) values (1485,'EA_APPROVE_STATUS','审批状态',1,'1','进行中',null);