Re: Granting rights to Procedures

From: <michael_bialik_at_my-deja.com>
Date: Thu, 23 Sep 1999 21:16:41 GMT
Message-ID: <7se5bd$qhg$1@nnrp1.deja.com>

Hi.

Does GRANT EXECUTE ON <proc-name> TO <user1>, <user2>... is good enough?

Michael.

In article <7se2c8$o9n$1_at_nnrp1.deja.com>, akkha_at_my-deja.com wrote:
> Hi,
>
> How do I grant,say a bunch of stored procedures
> of one schema to another bunch of users for
> updating etc. Granting alter all procedures privlige
> is not a good alternative at all as it would allow
> them to go and alter/drop others (say, system or sys or case)
> procedures.
>
> Thanks for any help.
>
> Anthony
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 23 1999 - 16:16:41 CDT