--建立用户分配权限
create user groper identified by groper
/
 grant connect,resource to groper
/
grant create  synonym  to groper
/
--赋予视图权限

begin

grant select on FYBJY.V_LQT_DIAGNOSIS  to  groper;

grant select on FYBJY.V_LQT_DIC_DEPT  to  groper;

grant select on FYBJY.V_LQT_DIC_DRUG  to  groper;

grant select on FYBJY.V_LQT_DIC_EMPLOYEES  to  groper;

grant select on FYBJY.V_LQT_DIC_ICD10  to  groper;

grant select on FYBJY.V_LQT_EMR  to  groper;

grant select on FYBJY.V_LQT_OPER  to  groper;

grant select on FYBJY.V_LQT_ORDERS  to  groper;

grant select on FYBJY.V_LQT_STOOL  to  groper;

grant select on FYBJY.V_LQT_TEMP  to  groper;

grant select on FYBJY.V_LQT_VISIT_ZY  to  groper;

grant select on FYBJY.V_LQT_ZKMX  to  groper;

end;

/
--登录groper用户创建同义词


create or replace synonym V_LQT_DIAGNOSIS for FYBJY.V_LQT_DIAGNOSIS  

create or replace synonym V_LQT_DIC_DEPT for FYBJY.V_LQT_DIC_DEPT  

create or replace synonym V_LQT_DIC_DRUG for FYBJY.V_LQT_DIC_DRUG  

create or replace synonym V_LQT_DIC_EMPLOYEES for FYBJY.V_LQT_DIC_EMPLOYEES  

create or replace synonym V_LQT_DIC_ICD10 for FYBJY.V_LQT_DIC_ICD10  

create or replace synonym V_LQT_EMR for FYBJY.V_LQT_EMR  

create or replace synonym V_LQT_OPER for FYBJY.V_LQT_OPER  

create or replace synonym V_LQT_ORDERS for FYBJY.V_LQT_ORDERS  

create or replace synonym V_LQT_STOOL for FYBJY.V_LQT_STOOL  

create or replace synonym V_LQT_TEMP for FYBJY.V_LQT_TEMP  

create or replace synonym V_LQT_VISIT_ZY for FYBJY.V_LQT_VISIT_ZY  

create or replace synonym V_LQT_ZKMX for FYBJY.V_LQT_ZKMX  


/