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_USERAuthor: Jack Vamvas (http://www.sqlserver-dba.com)