Post reply

how to restrict user to create/alter Stored Procedures only

  • September 12, 2008 at 6:46 pm

    #94128

    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

    #871438

    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.

  • December 3, 2008 at 9:54 am

    #907005

    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