create or replace view emp_view
as
select deptno,count(*) total_employeer,sum(sal) total_salary
from emp
group by deptno
ORA-01031: 权限不足
SQL> show user;
User is "scott"
首先使用system帐户进行登录。
SQL> grant create any view to scott;
Grant succeeded