Thursday , April 25 2024

How To Find Users Authorized at Server-Level On SQL Server

 

No one should be authorized at server level on instance except DBAs.

In some cases, as an exception, you may be granted some users through user defined roles at server level. But I wouldn’t advise you to do that unless you have to. If you authorize others on Instance, you cannot know if any errors that may occur are due to an action that these users make.

In addition, for security purposes, you do not want to share the responsibility of a system you manage with anyone.

Especially, sysadmin authorization should only be given to DBAs.

With the help of the script below, you can find out which user is authorized at the server level.

Loading

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories