What is the proper db role for this user?

[PTW]

Hello Everyone,

On one of our SQL Servers, I want to allow a user to be able to add or modify things like Views and Stored Procedures, including granting permission to them if possible. However, I do not want him to be able to add or modify any other kind of user security.

Is there a fixed database role that can do this? Are there any combinations of access I can grant to him to let him do this? We are using SQL 2000. Thanks!

 

[mrdenny]

db_ddladmin "should" do the trick.

Denny

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

http://www.mrdenny.com

(My very old site)