See the FAQ pages listed below.
Search on 'insufficient privileges'.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Rich wrote in message <6KF88.20133$5K1.3327457_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 - 02:38:01 CST
