How can I grant a user create/alter index permissions without giving db_ddladmin? I want them to have the minimum permissions possible.
Sql-server – CREATE/ALTER INDEX permission
permissionssql server
Related Question
- MySQL – Preserve Execute Permissions for Procedure with ALTER PROCEDURE
- SQL Server – Minimum Privilege Required to Create a Full Text Index
- MySQL – How to Create a User with Privileges to Create Users
- SQL Server Role – Server Role with Permission Only to Create Server Login
- Sql-server – Create table permission for a user in specific schema
- SQL Server Permission to Truncate Table
Best Answer
The minimum
permission
tocreate
/alter
index can be easily found in corresponding BOL articles CREATE INDEX (Transact-SQL) and ALTER INDEX (Transact-SQL):This means you can grant
alter table
on everytable
of interest that already exists.If you don't want to grant so granular
permissions
you can grantalter on schema(s)
where your table(s) reside, this will assure that the user would be able tocreate
/alter
indexes on any futuretable
/view
.