• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • Last Modified:

Create index permissions

Pls advise how I can grant create index permissions in sql without granting sysadmin rights
0
Sonali P
Asked:
Sonali P
  • 2
1 Solution
 
Scott PletcherSenior DBACommented:
Grant them ALTER on the underlying table or view.  That will give them more than just index create authority, but I don't know right now if there is any way to limit it more.
0
 
Scott PletcherSenior DBACommented:
I still haven't found another way to limit it to only CREATE INDEX.  SQL Server still needs more granularity in some permissions :-).
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now