what is server roles in sql server?

Question

Hi in Sql server 2008 in security folder in seen Server roles.What is roles of it?

Manas Mohapatra · Answer

It is used to manage permission in server. These are kind of security groups which be assigned to a user in sqlserver. You can also create user definedserver roles from 2012 onwards. Server roles arebulkadmin dbcreator diskadmin processadmin securityadmin serveradmin setupadmin sysadmin etc. Moreover go through below link: https://msdn.microsoft.com/en-us/library/ms188659.aspx

Vasanth Natarajan · Answer

Hi. They are intended for use in administering SQL Server and the permissions assigned to them cannot be changed. Logins can be assigned to fixed server roles without having a user account in a database. The sysadmin fixed server role encompasses all other roles and has unlimited scope. https://msdn.microsoft.com/en-us/library/bb669065(v=vs.110).aspx