Oracle Scott CREATE view insufficient resolution _oracle

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.