创建视图
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文章来源：https://www.toymoban.com/news/detail-735071.html
创建用户
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（用户名） ;文章来源地址https://www.toymoban.com/news/detail-735071.html
到了这里，关于oracle创建视图 并分配用户的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！
