Re: Unable to Read table in STORED PROCEDURE

From: MarkyG <markg_at_mymail.tm>
Date: 8 Feb 2002 07:45:09 -0800
Message-ID: <ab87195e.0202080745.4968156@posting.google.com>

Make sure you have been granted read privs explicitly as opposed to via a role.

Mark

abc_at_email.com (Rich) wrote in message news:<GNF88.20224$5K1.3330433_at_news20.bellglobal.com>...
> I am trying to SELECT from a table within my Stored procedure but
> it was unable to compile and complained about view or table not found.
>
> This table was not created under someone's ID. However, I was able to SELECT
> from it on the command line, like isql.
>
> The problem only happens in the stroed procedure.
>
> Any ideas?
>
> Please email to rkwok_at_sympatico.ca
>
> Thanks in advance
> Vicky
Received on Fri Feb 08 2002 - 09:45:09 CST