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]
Give ES11en users permission to create ES12en
[sql]
[sql]
View created successfully
[sql]
(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;