Re: ORA-00942: Table or View does not exist????

In article <3942703B.2295BAD8_at_iquest.net>,   David Van Zandt <dvanzandt_at_iquest.net> wrote:
> You may wish to include the code sample next time. But sight unseen,
 it
> sounds like your SQL statement omits the schema. qualifier (as in
> tableowner.tablename), and that he/she has not created a public
 synonym
> for it.
>
> HTH,
> dvz
>

Or better yet create a public synonym for the object so that the schema is not required in the SQL statement.

> Bobby wrote:
> >
> > I get this error even after a tableowner gives insert,select, delete
> > permissions to other users, (even PUBLIC).
> >
> > Other users can't even see the table. What could be wrong?
> >
> > I am using Oracle 8.1.6 on NT.
> >
> > PLEASE HELP!!!
> >
> > Thanks in advance.
> >
> > bobby25_at_rocketmail.com
>

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.