||MS SQL Server Administration: Server Roles
Roles, a new feature of SQL Server 7.0 which was not with earlier versions, perform like Windows NT local group. Server roles is one of the several roles supported by MS SQL Server, the others being database and application roles.
At the server level is defined the server roles which lie outside users databases. Server roles are fixed and cannot be added, deleted or modified. Users can only be added as server roles member.
Fixed server roles are of seven types- sysadmin, serveradmin, setupadmin, securityadmin, processadmin, dbcreator and diskadmin. All activities in SQL Server can be performed by sysadmin server role members and overall database functions are completely controlled by them. The function of the members of the serveradmin server role is to change server configuration parameters and shutting down of the server. Setupadmin server role members can add or remove linked servers, manage replication and extended stored procedures. Some system stored procedures like sp serveroption can be executed by this role. Creation and management of server logins and auditing and reading error logs are done by securityadmin server role members. Management of the processes that run in SQL Server is done by processadmin server role members. Database creation, alteration and resizing are the functions of dbcreator server role members. Disk files are managed by diskadmin server role members.