Re: Granting rights to Procedures

You may be better off in the longing run creating a role (e.g. DEVEL) and granting the rights to the role. You have the added step of granting the role to the developers but any additions or deletions that you make to your procedure list is handled through the role and not by granting to the individual users.

Hope this helps.

Byron Lee

Rod Stewart wrote:

> A common way around this is to have all developers logging in as the same
> user, for example 'DEV'. That way you have the one schema that owns all of
> the system you are developing.
>
> <akkha_at_my-deja.com> wrote in message news:7segkd$2f4$1_at_nnrp1.deja.com...
> > 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.
Received on Tue Sep 28 1999 - 11:02:43 CDT