I'm looking for official documentation that details what ALTER SERVER STATE grants a user in Microsoft SQL.

Andy 86 Reputation points
2021-10-28T15:44:22.927+00:00

Hello.

Can anyone point me in the direction of documentation that details what "ALTER SERVER STATE" grants a user in Microsoft SQL.

I have found a few articles and the most information I've been able to gain so far is that it grants or denies the ability to manage some aspects of the server, such as DBCC FREEPROCCACHE, and DBCC FREESYSTEMCACHE. It also allows the user to stop and start a SQL Instance.

Ideally I need as detailed as possible.

Thanks.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,666 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2021-10-28T18:08:11.047+00:00

    There is not any official MS documentation for this option.

    Basically it allows start, stop, view the SQL Server service. The DBCC cache commands are kind of related to "managing the service".

    The best documentation you will find is what REQUIRES it.

    0 comments
  2. Seeya Xi-MSFT 16,436 Reputation points
    2021-10-29T05:58:41.557+00:00

    Hi @Andy ,

    SQL Server's 'Alter server state' permission is a higher server-level privilege that must only be granted to individual administration accounts through roles. This administrative privilege must not be assigned directly to administrative user accounts (or any other user accounts).
    Quote from this link: https://www.stigviewer.com/stig/microsoft_sql_server_2012_database_instance/2015-12-21/finding/V-41248

    You can refer to the link above. Hope this is useful to you.

    Best regards,
    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments