Error: Insufficient permissions when creating a view under scott user. (Other users do the same)

Solution: Log in as dba user [sql]

sqlplus / as sysdba

Give ES11en users permission to create ES12en [sql]

grant create view to scott
 In order to scott The user login oracle

[sql]

conn scott/tiger

View created successfully

[sql]

CREATE OR REPLACE VIEW myview AS
SELECT * FROM emp where deptno = 20;