In the Pl/sql Developer Database management tool, log in with the Scott user account, create a new SQL query window, enter an SQL statement to create the view, and then pop up an error message: ORA-01031: Insufficient permissions.
The error message shown above is very clear, this is due to insufficient permissions! So, as long as we set a Scott user's permissions can be solved!
Check on the Internet, set user rights is to use grant, and create VIEW permissions are created view, then to give Scott user to create VIEW permissions of the statement is the following whole statement:
Grant CREATE view to Scott
How to operate:
1. The operation of the input cmd, determine;
2. Input sqlplus, carriage return;
3. Input system user, enter;
4. Input system password, enter;
5. Enter grant CREATE view to Scott;, carriage return, complete.
Error tip: Insufficient permissions! According to the above steps is not solved the problem, I hope this article can really help everyone.