oracle 10g中以scott登录,创建视图时候提示
CREATE VIEW empv20 AS SELECT empno,ename,job,hiredate FROM emp WHERE deptno=20
*
第 1 行出现错误:
ORA-01031: 权限不足
CREATE VIEW empv20 AS SELECT empno,ename,job,hiredate FROM emp WHERE deptno=20
*
第 1 行出现错误:
ORA-01031: 权限不足
grant create view to user;
grant create any view to scott;
grant create any view to scott;
conn sys/password as sysdba
DBA用户登陆
conn sys/password as sysdba
把创建视图的权限赋给scott用户
grant create any view to scott;