Monday , December 23 2024

Fixed Server Level Roles in SQL Server

 

These roles are the default server level roles at the instance level. You can find the brief description about these roles below.

sysadminsysadmins is the most authoritative user at Instance level. They can do everything.
serveradminserveradmins can change configuration at Instance level and turn off instance.
securityadminSecurity admins can manage the logins and reset their passwords, run “grant, deny, and revoke” commands at the instance level. They can also run “grant, deny, and revoke” commands on databases they have access to.
processadminprocessadmins can shut down a process on the instance.
setupadminsetupadmins can create and drop linked server using TSQL.
bulkadminbulkadmins can run “BULK INSERT” command.
dbcreatordbcreators can create or restore databases, and modify and drop existing database.
publicEven if no privileges are granted to each login created, it is the default privilege granted initially.

Apart from these roles, you can create server level roles. You can use the following article.

“How To Create a Server Level Role in SQL Server”

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 *