Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

ALTER INDEX permissions

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

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.