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.
DENY ALTER on My Table to MY_SQL_USER
Republished from http://www.sqlserver-dba.com.