Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!newsfeed.news2me.com!wn52feed!worldnet.att.net!attbi_s02.POSTED!not-for-mail Reply-To: "Jim Kennedy" From: "Jim Kennedy" Newsgroups: comp.databases.oracle References: Subject: Re: Oracle View Problem Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Message-ID: NNTP-Posting-Host: 24.20.5.156 X-Complaints-To: abuse@comcast.net X-Trace: attbi_s02 1083715313 24.20.5.156 (Wed, 05 May 2004 00:01:53 GMT) NNTP-Posting-Date: Wed, 05 May 2004 00:01:53 GMT Organization: Comcast Online Date: Wed, 05 May 2004 00:01:53 GMT Xref: core-easynews comp.databases.oracle:27523 X-Received-Date: Tue, 04 May 2004 17:01:28 MST (news.easynews.com) "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