When I created a view under a scott user, the following error was reported: The permission is insufficient. I was helpless when I encountered this problem. so I collected the information online and shared it with you. I hope to help you.
When I created a view under a scott user, the following error was reported: The permission is insufficient. I was helpless when I encountered this problem. so I collected the information online and shared it with you. I hope to help you.
Problem Description: When creating a view under the scott user, an error is reported: The permission is insufficient.
(Other users and so on)
Solution:
Log on as a dba user
[SQL]
The code is as follows:
Sqlplus/as sysdba
Grant scott the permission to create a VIEW
[SQL]
The code is as follows:
Grant create view to scott
Log on to oracle as a scott user
[SQL]
The code is as follows:
Conn scott/tiger
View created
[SQL]
The code is as follows:
Create or replace view myview
SELECT * FROM emp where deptno = 20;
