Server Roles In SQL Server 2008
In this article I will introduce you to various levels of access to server operations and tasks.
Today, I have provided an article showing you the various Server Roles in SQL Server. In this article I will introduce you to various levels of access to server operations and tasks. Server Roles are used to manage the permission on server.
Server Roles are predefined and grant the permission for the server. SQL Server provides several roles of server which are security principals and these principals also group other principals. Roles are like groups in the Microsoft Windows Operating System.
Server Roles are also called Fixed Server Roles because these roles are not a database specific and cannot be managed.
Accessing the Server Roles
To access the Server Roles, Go to SQL Server Management Studio->Expand Security Folder->Expand Server Roles. You will get the various Server Roles listed.
Explanation of the server roles defined in SQL Server 2008.
Server Role |
Description |
sysadmin |
Able to perform any task in SQL Server. |
serveradmin |
Able to change 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 |
Can end processes that are running in an instance of SQL Server. |
dbcreator |
Able to create and modify databases. |
diskadmin |
Able to manage disk files. |
bulkadmin |
Able to execute bulk insert statements. |