oracle怎么导出授权用户下的视图,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;