Re: How a user can execute stored procedure of some other user.

Hi Jurij,

Thanks for your reply.
I have used this like
USER_1.PROCEDURE_NAME
[Quoted] [Quoted] but it could not execute. What ideally it should be, I mean should we make synonyms for such procedures?

Regards,
Irfan

Jurij Modic wrote:

> On Thu, 10 Sep 1998 13:36:53 +0500, Irfan Lodhi <ilodhi_at_lums.edu.pk>
> wrote:
>
>
> Unless there is a synonym for this procedure, user-2 has to reference
> the full name of the procedure - that is OWNER_NAME.PROCEDURE_NAME. In
> your example, user_2 has to reference the user_1's procedure like:
>
> USER_1.PROCEDURE_NAME
>
> >Regards,
> >Irfan Lodhi
>
> HTH,
> --
> Jurij Modic <jmodic_at_src.si>
> Certified Oracle7 DBA (OCP)
> ================================================
> The above opinions are mine and do not represent
> any official standpoints of my employer
Received on Fri Sep 11 1998 - 07:29:49 CEST