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;