How can I grant a user create/alter index permissions without giving db_ddladmin? I want them to have the minimum permissions possible.
Requires ALTER permission on the table or view.
This means you can grant
alter table on every
table of interest that already exists.
If you don't want to grant so granular
permissions you can grant
alter on schema(s) where your table(s) reside, this will assure that the user would be able to
alter indexes on any future