Home Forums SQL Server 2012 SQL 2012 - General Re-indexing Job (Dynamic Management View permissions?) RE: Re-indexing Job (Dynamic Management View permissions?)

  • February 28, 2017 at 12:58 am

    #1930618

    From BOL:
    Requires the following permissions:

    • CONTROL permission on the specified object within the database.
    • VIEW DATABASE STATE permission to return information about all objects within the specified database, by using the object wildcard @object_id=NULL.
    • VIEW SERVER STATE permission to return information about all databases, by using the database wildcard @database_id = NULL.

    😎