oracle 测试视图,oracle 唯独测试视图

--建立用户分配权限

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

/

原文：https://www.cnblogs.com/CoreXin/p/11755487.html