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 行出现错误:
已连接。
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;
