In MS SQL database server some user have total access of the server so they can do what ever they want while some usiers can only able to manage security. To Limit the amount of administrative access for a user Server Roles are defined. All the server roles are described as under with highest administrative access granted:
1) Sysadmin:
Sysadmin have the authority to perform any task in SQL server. This role is only for the Database Administrators [DBA].
2) Serveradmin:
Serveradmin can set server wide configuration options. Like..how m,uch memory SQL server can use, how much information to send over the network in a single frame etc..,
3) Setupadmin:
Setupadmin can install replication and manage extended stored procedures.
4) Securityadmin:
Securityadmin user can manage security issues such as creating and deleting logins, reading the audit logs, granting users permissions to create database.
5) Processadmin:
SQL server can run more than one task at a time by executing multiple processes. Processadmin can ebd/kill a process whenever any suspecious or hanged process are running on the server.
6) DBCrateor:
DBCreator can create database for a user and maintain it.
7) Diskadmin:
Diskadmin can manage and maintain files on the disk.
Sign up or log in