Developers like to have some control over the development process. An example is index building.  Asking a DBA repeatedly for changes  to a Development Database  might not be the best use of time – for either parties.

For example, a developer may want to work over the weekend to finish a Data Import and Export  process

---To execute ALTER INDEX, at a minimum, ALTER permission on the table or view is required.
GRANT ALTER on My Table  to MY_SQL_USER

---To revoke the ALTER INDEX permissions.
GO
DENY ALTER on My Table  to MY_SQL_USER

Republished from http://www.sqlserver-dba.com.