Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!news.glorb.com!postnews1.google.com!not-for-mail
From: mhakimjavadi@hotmail.com (Mohammad)
Newsgroups: comp.databases.oracle
Subject: Oracle View Problem
Date: 4 May 2004 16:13:46 -0700
Organization: http://groups.google.com
Lines: 13
Message-ID: <cc59b627.0405041513.4147b93d@posting.google.com>
NNTP-Posting-Host: 207.35.158.35
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1083712426 15389 127.0.0.1 (4 May 2004 23:13:46 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 4 May 2004 23:13:46 +0000 (UTC)
Xref: core-easynews comp.databases.oracle:27522
X-Received-Date: Tue, 04 May 2004 16:13:21 MST (news.easynews.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