Post reply

Alter Index permission

  • September 29, 2016 at 12:47 am

    #330959

    I need to provide access to create and alter index for all DBs. Is there any possibility to provide the same in server level other than sysadmin

  • September 29, 2016 at 2:31 am

    #1903851

    No, sorry, it's not possible. What you want to grant is a database level permission and you'll need to add a user to each database for that, with the appropriate permissions.

    -- Gianluca Sartori

  • October 4, 2016 at 12:19 pm

    #1904724

    Why can't you create a server-level role that uses a SQL Login to access each DB with the ALTER INDEX permissions?

    Yes, initial setup will require you to touch each database, but once it's done, you can assign role permissions on the server-level role to any user you need to.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply