oracle View Permissions oracle View creation permissions are insufficient

  • 2021-01-06 00:47:12
  • OfStack

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; 

Related articles: