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

[Quoted] On Thu, 10 Sep 1998 13:36:53 +0500, Irfan Lodhi <ilodhi_at_lums.edu.pk> wrote:

>Hi all, Would anybody like to let me know that:
>
>How a user (user-1) can execute a stored procedure which is created by
>some other user (user-2), while the other user (user-2) has already
>given the Object Privilege 'EXECUTE' of that stored procedure to user-1.

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
>I'll be more than thankful to if somebody guide me in this regard. One
>other possibilitiy is to make synonyms for the stored procedures.
>
>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