Permission to edit stored procedure 1

[scc]

Is there a way to give permission to edit a stored procedure without giving complete DBA permissions?

Hope I'm wording this correctly, but I need to be able to edit an existing stored procedure on a database with out being given complete DBA control on all objects on the database. Is this possible?

 

[mrdenny]

See "GRANT, GRANT (described)" in BOL. You need to be dbo or db_ddladmin to alter someone elses procedures.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[scc]

I will check this out in BOL and see if I can make sense of it all. Again, I'm a programmer, not a network/Sql Server administrator. Which is why I'm posting hoping a SQL Server Administrator may jump in here.

But what you say isinteresting... "to edit someone else's stored procedures."

Is there a way to give me permission to create stored procedures and therefore able to edit my own stored procedures without giving me dbo or admin rights? The ownership then could be changed to dbo before it goes into production.

Maybe there is a way?

 

[mrdenny]

Yes there is.

grant create procedure to username

That same section in BOL has all the permissions that can be granted. Simply replace username with the username of the user that you want to be able to create procedures.

Once the procedure is ready to go into production, have the dba change the owner from username to dbo.

Denny

--Anything is possible. All it takes is a little research. (Me)