gdymtsceshi/WebContent/WEB-INF/complaint/doc/各系统接口文档/与MISS系统接口/oracle权限操作.txt

创建用户并分配权限：
-- 创建用户
create user hjzx
  identified by hjzx
  default tablespace USERS
  temporary tablespace TEMP
  profile DEFAULT;
-- 分配权限
grant connect to hjzx;
grant resource to hjzx;
grant dba to hjzx;

授权sql：把tsxt用户的某些表的查询权限分配给hjzx用户：
grant select on tsxt.DIC_CARDTYPE to hjzx;
grant select on tsxt.DIC_COMPLAINSECTION to hjzx;
grant select on tsxt.DIC_LEVELTYPE to hjzx;
grant select on tsxt.DIC_MANAGEFRUIT to hjzx;
grant select on tsxt.DIC_NETWORKMODE to hjzx;
grant select on tsxt.DIC_ORGTYPE to hjzx;
grant select on tsxt.DIC_PERSONALLY to hjzx;
grant select on tsxt.DIC_SOURCETYPE to hjzx;
grant select on tsxt.DIC_STATUSTYPE to hjzx;
-- 创建用户
create user hjzx
  identified by hjzx
  default tablespace USERS
  temporary tablespace TEMP
  profile DEFAULT;
-- 分配权限
grant connect to hjzx;
grant resource to hjzx;
grant dba to hjzx; grant select on tsxt.DIC_TRANSACTMODE to hjzx;
grant select on tsxt.J_REGION to hjzx;
grant select on tsxt.X_VISIT to hjzx;



视图查询sql：
     select * from tsxt.X_VISIT

字典同步查询sql：
select * from tsxt.DIC_CARDTYPE
select * from tsxt.DIC_COMPLAINSECTION
select * from tsxt.DIC_LEVELTYPE
select * from tsxt.DIC_MANAGEFRUIT
select * from tsxt.DIC_NETWORKMODE
select * from tsxt.DIC_ORGTYPE
select * from tsxt.DIC_PERSONALLY
select * from tsxt.DIC_SOURCETYPE
select * from tsxt.DIC_STATUSTYPE
select * from tsxt.DIC_TRANSACTMODE
select * from tsxt.J_REGION