用 grant 命令 比如 这样这样,用system登录 grant create session to testuser; grant create any view to testuser; grant select on table_name to testuser;conn testuser/password; create or replace view yourview as select * from system.table_name;
赋予用户create any view的权限
grant create session to testuser; grant create any view to testuser; grant select on table_name to testuser;conn testuser/password; create or replace view yourview as select * from system.table_name;在权限设置的时候赋予 可建的权限。 问题讨论到37048519
或者你用system用户登录肯定可以
比如
这样这样,用system登录
grant create session to testuser;
grant create any view to testuser;
grant select on table_name to testuser;conn testuser/password;
create or replace view yourview as select * from system.table_name;
grant create any view to testuser;
grant select on table_name to testuser;conn testuser/password;
create or replace view yourview as select * from system.table_name;在权限设置的时候赋予 可建的权限。
问题讨论到37048519