Online Documentation for SQL Manager for SQL server
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.
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.
Server Role Editor allows you to define server role properties. It opens automatically when you create a new server role and is available on editing an existing one.
To open a server role in Server Role Editor, double-click it in the DB Explorer tree or in the Server Role Manager. Alternatively, you can right-click the server role alias and select the Edit Server Role context menu item.
- Setting server role parameters
- Defining server permissions
- Defining server role permissions
- Defining login permissions
- Defining endpoint permissions