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;

posted @ 2016-05-05 21:47  172257861  阅读(142)  评论(0编辑  收藏  举报