Results 1 to 5 of 5

Thread: Creating a View

  1. #1
    Join Date
    Oct 2011
    Posts
    7

    Unanswered: Creating a View

    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!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2011
    Posts
    7

    Still Looking!

    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?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by jmax View Post
    still cannot create view.
    And the error message is?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •