授权相关

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