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
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
Explanation of the server roles defined in SQL Server 2008.
||Able to perform any task in SQL
||Able to change SQL Server settings and
shut down SQL Server.
||Able to install replication and
control extended stored procedures.
||Able to control server logins and
create database permissions.
||Can end processes that are running in
an instance of SQL Server.
||Able to create and modify databases.
||Able to manage disk files.
||Able to execute bulk insert