microsoft.public.sqlserver.server - permission on store procedure

Author

permission on store procedure

Kathy Chen

2002-11-20, 4:23 pm

Is there a way to set default permission of a role to all new store
procedure to exec? So we don't need grant the exec permission to every new
store procedure we created.

thanks

kathy

Tibor Karaszi

2002-11-21, 6:23 am

No, there's no such fixed server role. See the prior recommendation to create a job which does
this regularly.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver

"Kathy Chen" <kathy_chen@hotmail.com> wrote in message news:eoY6OrNkCHA.1736@tkmsftngp11...
> Is there a way to set default permission of a role to all new store
> procedure to exec? So we don't need grant the exec permission to every new
> store procedure we created.
>
> thanks
>
> kathy
>
>

Sponsored Links