Modify an object without being the owner?

[PTW]

We have two developers who both at times need to make changes to a handful of Views for some of their own internal reports.

However, to my knowledge the only way to allow someone to make a change to a View is to either be the View's owner or the database's owner.

If there ay other way to set a permission to allow changes to a View without giving full ownership? Or give ownership to multiple users?

Thanks.

 

[JamesLean]

From BOL:

ALTER VIEW permissions default to members of the db_owner and db_ddladmin fixed database roles, and to the view owner. These permissions are not transferable

--James

 

[mrdenny]

Yep, db_ddladmin is the way to go here. The build in database roles are very handy.

Denny
MCSA (2003) / MCDBA (SQL 2000)

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

http://www.mrdenny.com

(Not quite so old any more.)

 

[JohnDTampaBay]

Be aware that db_ddladmin has permissions to execute ANY ddl statements including DROP and CREATE.

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[PTW]

Thanks everyone. Can I limit the ddl statement access to only certain objects though? It's their Views--they can do whatever they want with them--but I don't wan them to touch anything else.

 

[JohnDTampaBay]

db_ddladmin is a database role, applies to the entire database.

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)