Oracle View Problem

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Mohammad
    #1

    Oracle View Problem

    Hi all

    I try to Create a view in Oracle 9i with 4 tables. But I got this error.

    (SELECT SUBMAIL_ID FROM GENERAL.SUBMAIL
    *
    ERROR at line 91:
    ORA-01031: insufficient privileges

    Could you please tell me how can I fix this error.

    Thanks
    Mohammad
    Tags: None
    • Jim Kennedy
      #2
      Re: Oracle View Problem


      "Mohammad" <mhakimjavadi@h otmail.comwrote in message
      news:cc59b627.0 405041513.4147b 93d@posting.goo gle.com...
      Hi all
      >
      I try to Create a view in Oracle 9i with 4 tables. But I got this error.
      >
      (SELECT SUBMAIL_ID FROM GENERAL.SUBMAIL
      *
      ERROR at line 91:
      ORA-01031: insufficient privileges
      >
      Could you please tell me how can I fix this error.
      >
      Thanks
      Mohammad
      You do not have rights to select that column from the table. You need to
      grant yourself select privileges on the object.
      Jim


        Comment

        • Dave
          #3
          Re: Oracle View Problem

          "Jim Kennedy" <kennedy-downwithspammer sfamily@attbi.n etwrote in message news:<R9Wlc.244 36$_41.1747560@ attbi_s02>...
          "Mohammad" <mhakimjavadi@h otmail.comwrote in message
          news:cc59b627.0 405041513.4147b 93d@posting.goo gle.com...
          Hi all

          I try to Create a view in Oracle 9i with 4 tables. But I got this error.

          (SELECT SUBMAIL_ID FROM GENERAL.SUBMAIL
          *
          ERROR at line 91:
          ORA-01031: insufficient privileges

          Could you please tell me how can I fix this error.

          Thanks
          Mohammad
          >
          You do not have rights to select that column from the table. You need to
          grant yourself select privileges on the object.
          Jim

          Or you may not have privileges to create a view in the schema you are
          trying to create in (Either your own or another.)

            Comment

            Previous template Next
            Working...