Oracle创建视图权限不足

创建用户后需要给当前用户授权

--创建用户
create user gfa_gom identified by 1;
alter user gfa_gom identified by 1;
--授权
grant create session to gfa_gom;
grant unlimited tablespace to gfa_gom;
grant create table to gfa_gom;
grant drop table to gfa_gom;
grant insert table to gfa_gom;
grant update table to gfa_gom;
grant create view to gfa_gom;
grant delete any table to GFA_GOM;

如果创建跨用户的视图

CREATE OR REPLACE VIEW GFA_GOM.V_test AS
SELECT aaa from PROJLIB.V_formula;

报错：创建视图权限不足

则需要在提取数据的那个用户那边给这个用户授权

即登录PROJLIB用户为GFA_GOM授权，如

grant create  view to GFA_GOM; 

--授予查询权限 
grant select any table to GFA_GOM; 

--授予权限 
grant select any dictionary to GFA_GOM;