To get Index object properties, users can be a member of the public fixed server role.
To set Index object properties, create or drop an index, update statistics on an index, or rebuild, reorganize, or re-create an index, users must have one of the following:
-
ALTER permission on the parent table or view
-
Membership of the db_owner or the db_ddladmin fixed database roles
-
Membership of the sysadmin fixed server role