Server Roles In SQL Server 2008

In this article I will introduce you to various levels of access to server operations and tasks.
  • 2076

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.

ServerRoles.jpg

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.

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.