How to assign exec permissions on all user defined SPs for specific user

How to assign exec permissions on all user defined SPs for specific user

Post by moondadd » Fri, 10 Dec 2004 02:02:22


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
 
 
 

1. Assigning User Passwords - User-Defined Type Not Defined error

2. How to allow grant,,permission an specific assigned user/group to add workstation to the domain?

Hi,

I disabled the permission to add workstation to the domain per
Authenticated group years
ago due to the problem that users keep joinning their workstation to the
domain.

However, we now have more member in IT, we might limit the right not to give
them the domain admin right, so we look ways to reactivate to assign an
user/group to be able to
add workstation to domain without limited times (previously was 10 times to
add workstation,
which I removed). Now I don't remember where to look for re-enabling it. Can
someone help?


Thanks,
J.H

3. How to allow grant,,permission an specific assigned user/group to

4. How to allow grant,,permission an specific assigned user/group

5. How to: User Form to assign a user defined range to a macro variab

6. Assign permissions to create other users to Users account

7. PWA Admin Manage Users - Specific user missing permissions

8. =?x-user-defined?Q?_=93Minus_12_GB_Memory_on_the_Hard_Disk=94_says_Sys?= =?x-user-defined?Q?tem_Performance_tableau_in_Windows_ME?=

9. User defined precedence for user defined operators.

10. User-defined type in user-defined function

11. User-defined data type; Error: Only User-defined types...

12. Memory Difference Between User-Defined Pointer and User-Defined Allocatable

13. Show user-defined comments for user-defined functions

14. User account slow login, specific user account on specific desktop

15. Local user groups, how to assign users to Power Users grp?