Minimal access to create an index on any table

• Roust_m

  SSCoach

  Points: 17410

  More actions

  March 19, 2009 at 1:01 am

  #132157

  From BOL 2008:

  Permissions

  Requires ALTER permission on the table or view. User must be a member of the sysadmin fixed server role or the db_ddladmin and db_owner fixed database roles.

  Is it really the only way? What is the point of having "db_ddladmin and db_owner" if db_owner has it all db_ddladmin has?

• dmoldovan

  SSCertifiable

  Points: 6334

  More actions

  March 19, 2009 at 2:02 am

  #962517

  Maybe an "or" instead of the "and" would be more appropriate...

  See also http://msdn.microsoft.com/en-us/library/ms189612.aspx