question

DBA-Bandy avatar image
0 Votes"
DBA-Bandy asked SeeyaXi-msft commented

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

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-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DBA-Bandy ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

0 Votes 0 ·
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @DBA-Bandy,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.