Re: privilege prob
From: Lambert Caljouw <Lambert.Caljouw_at_boekhuis.nl>
Date: 1997/03/24
Message-ID: <01bc388f$e0016d80$ec3e4fc1_at_lambert-caljouw>#1/1
Date: 1997/03/24
Message-ID: <01bc388f$e0016d80$ec3e4fc1_at_lambert-caljouw>#1/1
Try 'create public synonym P for P;' from the user GENERAL. That way, it's known to all users by the name P (I bet the other package you are referring to HAS a synonym to it...)
Keep sharp, Lambert
-- _/_/_/_/_/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/_/ _/ _/ _/ _/ _/ _/ _/_/_/_/ _/ _/ _/ _/ _/_/ _/ _/ _/ _/ _/ _/ _/ _/_/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ Dave Menendez <dmnendez_at_olivet.edu> wrote in article <33307074.10E6_at_olivet.edu>...Received on Mon Mar 24 1997 - 00:00:00 CET
> Can someone help:
>
> Using Oracle7...
>
> I have one schema, GENERAL, and have a package P. I grant execute
> privilege on P to PUBLIC. Another user tries to declare a variable with
> a type declaration contained in package P, but SQLPLUS says that
> P.whatevertype must be defined. It only works if the user declares the
> variable as type GENERAL.P.whatevertype. Why does the user need to
> explicitly name the schema? I have another package with the same type
> of setup and users do not need to explicitly state the schema name...
>