Re: Granting rights on a Stored Procedure

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 29 Jul 1998 03:00:52 GMT
Message-ID: <35c58b09.12706403@netnews.worldnet.att.net>

On 28 Jul 98 22:30:33 GMT, dolans_at_stripe.Colorado.EDU (Sean Dolan) wrote:

> I have created a stored procedure in Oracle Form Builder and works fine. the problem is that it works when the owner of the stored procedure executes it. I would like to grant it to another user. The stored procedure is within a table space and called "INDEXIT". How would I go about granting the rights to execute this procedure to another user, say 'USERB'?

From SQL*Plus, execute the following:

GRANT EXECUTE ON indexit TO userb;

You must be logged on as the procedure's owner in order to do this. You may also find a synonym helpful, so that all users can reference the procedure as simple INDEXIT, rather than USERA.INDEXIT. To create on, execute:

CREATE PUBLIC SYNONYM INDEXIT FOR USERA.INDEXIT; HTH, Jonathan Received on Tue Jul 28 1998 - 22:00:52 CDT