Creating a View

jmax · #1 (**permalink**) 12-03-11, 00:28

I am trying to create a simple view, it seems oracle will not allow me to do this because I have insufficient privileges. I keep reading and using google and still to no avail cannot get it to work.....So I am here again...Thanks in advance.

CREATE VIEW SupplierTotal AS
SELECT companyname, phone
FROM supplier;

Tried this, does not work...
grant select on supplier to "me";

Any help would be great!

Thanks again!

anacedent · #2 (**permalink**) 12-03-11, 00:36

It works for me!

Code:

SQL> create table supplier (companyname varchar2(30), phone varchar2(20));

Table created.

SQL> CREATE VIEW SupplierTotal AS SELECT companyname, phone FROM supplier;

View created.

jmax · #3 (**permalink**) 12-03-11, 00:50

Funny thing is I can just use select and it works, still cannot create view. Could there be a constraint I need to remove? Or am I just...missing the picture?

anacedent · #4 (**permalink**) 12-03-11, 10:51

which schema is logged in & trying to make VIEW?
does current schema have CREATE VIEW privilege?
does current schema have SELECT privilege on table SUPPLIER?

shammat · #5 (**permalink**) 12-04-11, 07:25

Quote:

Originally Posted by jmax

still cannot create view.

And the error message is?

Internet Services

Web Development

Digital Marketing

Consumer Tech