Oracle 授权另外一个用户拥有创建视图的权限

在另外一个用户登录的账号内输入这三条命令

grant create view to ds_leader;

grant select any table to ds_leader;

grant select any dictionary to ds_leader;

然后创建视图

create or replace view t_dm_ay as

select zdxbm bh,

      zdxbm dm,

      mc,

      px    xh,

      sfyx  yxbz,

      0    scbz,

      cjsj  sjc,

      KZSX0 jz,

      KZSX1 qc,

      fzdxid sjbh

  from DSPORTAL.t_tyqx_ywzdx

where zddybm = 'BASIC_AY'

  and fzdxid is null

union all

select b.zdxbm bh,

      b.zdxbm dm,

      b.mc,

      b.px    xh,

      b.sfyx  yxbz,

      0      scbz,

      b.cjsj  sjc,

      b.KZSX0 jz,

      b.KZSX1 qc,

      a.zdxbm sjbh

  from (select zdxid, zdxbm, fzdxid, mc, px, sfyx, cjsj, KZSX0, KZSX1

          from DSPORTAL.t_tyqx_ywzdx

        where zddybm = 'BASIC_AY') a,

      (select zdxid, zdxbm, fzdxid, mc, px, sfyx, cjsj, KZSX0, KZSX1

          from DSPORTAL.t_tyqx_ywzdx

        where zddybm = 'BASIC_AY') b

where a.zdxid = b.fzdxid;