Skip to main content
Version: 2024.1

Fixed Server Roles

The following table describes fixed server roles. For more information, see the Microsoft Fixed Server-Level Roles article.

note

The roles may change depending on the SQL Server version.

RoleDescriptionRequired for?
sysadminMembers of the sysadmin fixed server role can perform any activity in the server, for example, set up and maintain the system or server.Required for High Availability (HA) and Quali Server
serveradminMembers of the serveradmin fixed server role can change server-wide configuration options and shut down the server.Required for HA
securityadminMembers of the securityadmin fixed server role manage logins and their properties. They can GRANT, DENY, and REVOKE server-level permissions. They can also GRANT, DENY, and REVOKE database-level permissions if they have access to a database. Additionally, they can reset passwords for SQL Server logins.Used only by DB admin
processadminMembers of the processadmin fixed server role can end processes that are running in an instance of SQL Server.Might be required during installation
setupadminMembers of the setupadmin fixed server role can add and remove linked servers by using Transact-SQL statements. (sysadmin membership is needed when using SQL Management Studio.)Required for HA
bulkadminMembers of the bulkadmin fixed server role can run the BULK INSERT statement.Required during normal operation
diskadminThe diskadmin fixed server role is used for managing disk files.Not required from app perspective
dbcreatorMembers of the dbcreator fixed server role can create, alter, drop, and restore any database.Required during installation
PublicEvery SQL Server login belongs to the public server role. When a server principal has not been granted or denied specific permissions on a securable object, the user inherits the permissions granted to public on that object. Only assign public permissions on any object when you want the object to be available to all users. You cannot change membership in public.Required during normal operation