Developer Forum

I have a user I created in SQL server 2k which will be used by web services
and I don't want to assign dbo permissions to this user, but I do want to
assign exec permissions on all the stored procedures I created. Do I have
to manually check each SP in the permissions for that user to assign exec
permissions? Or is there a way to do it in one step for all SPs? Or is
there a way to allow that user to automatically have exec permissions on all
User defined SPs (because I'm constantly creating new ones and it would be
an admin nightmare to keep up to day on assigning permissions)?

Thanks

--
XXXX@XXXXX.COM