oracle dba create view 失败 解决办法

sql> conn /as sysdba

已连接。

sql> create or replace view scott.view_1 as select * from sh.customers;

create or replace view scott.view_1 as select * from sh.customers

                                                        *

第 1 行出现错误:

ora-01031: 权限不足

处理办法：

  grant create any table to scott;

  grant select any table to scott;

  grant comment any table to scott;

  grant lock any table to scott;

  grant select any dictionary to scott;

  grant create any table to sh;

  grant select any table to sh;

  grant comment any table to sh;

  grant lock any table to sh;

  grant select any dictionary to sh;