Re: Oracle View Problem

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:<R9Wlc.24436$_41.1747560_at_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

Or you may not have privileges to create a view in the schema you are trying to create in (Either your own or another.) Received on Wed May 05 2004 - 22:39:04 CEST