oracle创建视图 并分配用户

创建视图
create view VI_BR_SURGICAL_INFO（视图名） as
select a.BRID,a.BRXM,a.HISSQDH,VISIT_ID,b.SSMC as opm_oprt_name ,b.SSDM as opm_oprt_code,
a.MZFF as anst_way,a.MZYS as anstdr_code, a.SSYS as oper_dr_code ,a.OPER_BEGIN as opm_oprt_begntime ,a.OPER_END as opm_oprt_endtime , a.ANES_BEGIN as anst_begntime,a.ANES_END as anst_endtime,a.ssid,
b.jlxh as ssmx_id
from MZ_SS_SSGL a ,MZ_SS_SSMX b where a.SSID = b.SSID

创建用户
CREATE USER XXX（用户名） IDENTIFIED BY password（密码）;
授权登录
grant connect to XXX（用户名）
权限设置
GRANT SELECT on VI_BR_SURGICAL_INFO TO XXX（用户名）;
回收权限
revoke select on VI_BR_SURGICAL_INFO（视图名） from XXX（用户名） ;