Solution to Oracle Scott lack of view permissions, oraclescott
In PL/SQL Developer database management tools, log on with the SCOTT user account, create an SQL query window, enter an SQL statement to create a view, and then an error message is displayed: ORA-01031: insufficient permissions.
The error message shown is already clear. This is caused by insufficient permissions! Therefore, we only need to set the permissions of a scott user!
After checking on the internet, set the user permission to grant, and create view to create view, the statement to grant the scott user the permission to create view is the following:
Grant create view to scott
Procedure:
1. Enter cmd in the running process and click OK;
2. Enter sqlplus and press Enter;
3. Enter the system user and press Enter;
4. Enter the system password and press Enter;
5. Enter grant create view to scott; and press Enter.
Error message: the permission is insufficient! I hope this article will help you solve the problem according to the above steps.