Re: Development vs Test

The procedure that you created needs to have select privileges on the table.

Herman, DCI-OKC

In article <7beo8m$vaq$1_at_nnrp1.dejanews.com>,   avilner_at_usa.net wrote:
> Hello,
>
> We have a schema (DEV) in the database, that owns all tables, indexes,
> sequences, etc. There is also a set of public synonyms on the objects. If I
> were to log in with my user ID (ABV), I can issue the following query:
>
> select count(*)
> from PROP_HDR_142;
>
> In this case, public synonyms are used to resolve the reference to the
> DEV.PROP_HDR_142.
>
> However, if I try to create procedure:
>
> create or replace procedure proc_test
> is
> i number;
> begin
> select count(*)
> into i
> from prop_hdr_142;
> end;
> /
> show errors;
>
> ... I get the following error:
> 7/7 PLS-00201: identifier 'DEV.PROP_HDR_142' must be declared
> 5/2 PL/SQL: SQL Statement ignored
>
> I have CREATE PROCEDURE privilege granted to user ABV, and ABV also has
> SELECt/INSERT/UPDATE/DELETE privileges on all of DEV's tables.
>
> Why would the SELECT work, but not the procedure?
>
> Thank you in advance.
>
> Alex Vilner
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 02 1999 - 01:09:21 CST