November 20, 2002 at 8:30 am
I have a role set up on our Dev server called Developer which allows our developers to create/modify/delete tables/stored procs, ect. This role is assigned to their NT logins so when they create an object it is owned by that user and is prefixed by their nt login. IE, bobjo.sp_something. This also allows them implicit execute rights to their own procedures. Is there a way to allow all other users within the Developer role rights explicit execute rights to everyone elses procedures? This would eliminate me having to go in and grant execute to all these other nt users on everyone elses stored procedures.
Thanks
Edited by - cazar on 11/20/2002 08:32:11 AM
November 20, 2002 at 10:12 am
Make sure that at the bottom of each SP script is a line.
GRANT EXECUTE sp_something TO Developer
That should do it.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
November 20, 2002 at 8:47 pm
How about this:
GRANT
- WITH GRANT OPTION
Specifies that the security_account is given the ability to grant the 'specified' object permission to the other security accounts.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply