September 12, 2008 at 6:46 pm
Hi,
I want the development team to be able to create/alter Stored Procedures only. It would appear the only way to give them this permission is with the db_ddladmin authority. Giving them this much power opens up a huge security issue so I just want to restrict them to managing SPs. Is there any way of doing this using SQL Server 2000.
Many Thanks in advance...
September 13, 2008 at 11:20 am
You can grant the CREATE PROCEDURE permission to a role and the developers could do that. They wouldn't be able to create necessarily under the owner of DBO, but you could use sp_changeobjectowner when the procedures were set.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 3, 2008 at 9:54 am
HI,
As you have mentioned, we have given the GRANT access to create sp to the developer role but they are not able to alter the sp.
Is there any way where we can give permission to developer role to alter the sp
Or if we have to create a new role to give them access to alter existing sp's in db then how should we go about it ?
Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply