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

From: David Van Zandt <dvanzandt_at_iquest.net>
Date: 2000/06/10
Message-ID: <3942703B.2295BAD8@iquest.net>#1/1

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

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
Received on Sat Jun 10 2000 - 00:00:00 CDT