Re: Granting rights to Procedures

No, I want to grant the procedures for a bunch of developers so that they could do the code changes etc. I could give them my account username/password or grant alter all procedures privilges to them. But none of them is a good solution.

In article <7se55f$q7h$1_at_nnrp1.deja.com>,   michael_bialik_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 23 1999 - 19:29:13 CDT