|MS SQL Server 2012 - DBA Articles|
SQL Server - Server Level Fixed Roles
05. SQL Server - Server Level Fixed Roles
SQL Server provides server-level roles to help you manage the permissions on a server. These roles are security principals that group other principals. Server-level roles are server-wide in their permissions scope. (Roles are like groups in the Windows operating system.)
Fixed server roles are provided for convenience and backward compatibility. Assign more specific permissions whenever possible.
SQL Server provides nine fixed server roles. The permissions that are granted to the fixed server roles cannot be changed. Beginning with SQL Server 2012, you can create user-defined server roles and add server-level permissions to the user-defined server roles.
You can add server-level principals (SQL Server logins, Windows accounts, and Windows groups) into server-level roles. Each member of a fixed server role can add other logins to that same role. Members of user-defined server roles cannot add other server principals to the role.
The following table shows the fixed server-level roles and their capabilities.
More Reference URL: http://msdn.microsoft.com/en-us/library/ms188659%28v=sql.110%29.aspx
* * * * *