Server roles provide levels of access to server operations and tasks.
Server roles are predefined and grant the permission for the whole server. These roles are not database specific and cannot be customized. The table below provides a listing and explanation for each type of server role.
| sysadmin |
Able to do anything in SQL Server |
| serveradmin |
Able to modify SQL Server settings and shut down SQL Server |
| setupadmin |
Able to install replication and control extended stored procedures |
| securityadmin |
Able to control server logins and create database permissions |
| processadmin |
Able to control SQL Server processes |
| dbcreator |
Able to create and modify databases |
| diskadmin |
Able to manage disk files |
| bulkadmin |
Able to execute bulk insert statements |