Re: Oracle View Problem

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 05 May 2004 00:01:53 GMT
Message-ID: <R9Wlc.24436$_41.1747560@attbi_s02>

"Mohammad" <mhakimjavadi_at_hotmail.com> wrote in message news:cc59b627.0405041513.4147b93d_at_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 Received on Tue May 04 2004 - 19:01:53 CDT