Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!news.glorb.com!postnews1.google.com!not-for-mail From: davidr212000@yahoo.com (Dave) Newsgroups: comp.databases.oracle Subject: Re: Oracle View Problem Date: 5 May 2004 13:39:04 -0700 Organization: http://groups.google.com Lines: 24 Message-ID: <5e092a4e.0405051239.2324f883@posting.google.com> References: NNTP-Posting-Host: 204.110.99.42 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1083789544 4585 127.0.0.1 (5 May 2004 20:39:04 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 5 May 2004 20:39:04 +0000 (UTC) Xref: core-easynews comp.databases.oracle:27533 X-Received-Date: Wed, 05 May 2004 13:38:39 MST (news.easynews.com) "Jim Kennedy" wrote in message news:... > "Mohammad" wrote in message > news:cc59b627.0405041513.4147b93d@posting.google.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.)