grant create view on Oracle 11g

sql oracle11g privileges create-view
David Lacombe picture David Lacombe · Dec 15, 2013 · Viewed 74.4k times · Source

I use SQL*Plus for school and I use the username Scott. I cannot create views because it says:

ORA-01031: insufficient privileges;

I've searched and searched, but nothing seems to get it right. Any help?

Answer

mkubacki picture mkubacki · Dec 15, 2013

As the error states - your privileges are insufficient to create view - you will have to ask database administrator to grant you this privilege. If you can log in as database administrator you will have to execute statement(I can't guarantee correctness, no oracle database at hand)

GRANT CREATE ANY VIEW TO Scott;

or

GRANT CREATE VIEW TO Scott;

Related questions

How do I do top 1 in Oracle?

How do I do the following? select top 1 Fname from MyTbl In Oracle 11g?

Read More
Left Outer Join using + sign in Oracle 11g

Can any one tell me whether below 2 queries are an example of Left Outer Join or Right Outer Join?? Table Part: Name Null? Type PART_ID NOT NULL VARCHAR2(4) SUPPLIER_ID VARCHAR2(4) PART_ID SUPPLIER_ID P1 S1 P2 S2 …

Read More
Display names of all constraints for a table in Oracle SQL

I have defined a name for each of the constraint for the multiple tables that I have created in Oracle SQL. The problem is that to drop a constraint for the column of a particular table I need to know …

Read More