Re: How a user can execute stored procedure of some other user.
From: Arnold Schommer <aschommer_at_fs-edv.de>
Date: Fri, 11 Sep 1998 10:20:00 +0200
Message-ID: <35F8DD30.450266D4_at_fs-edv.de>
Date: Fri, 11 Sep 1998 10:20:00 +0200
Message-ID: <35F8DD30.450266D4_at_fs-edv.de>
Irfan Lodhi wrote:
>
> Hi Jurij,
>
> Thanks for your reply.
> I have used this like
> USER_1.PROCEDURE_NAME
> but it could not execute. What ideally it should be, I mean should we
> make
> synonyms for such procedures?
try to grant the execute right to the user that executes the proc'.
btw: In my experience, Oracle generally tends to treat objects that you
may not access similair to objects that do not exist.
>
> Regards,
> Irfan
>
> ...
Received on Fri Sep 11 1998 - 10:20:00 CEST