Online Documentation for SQL Administrator for SQL Server

Setting server role properties


Use the Properties tab of Server Role Editor to create/edit a role and specify its properties and membership.

 

Server Roles Editor - Properties

 

 

Name

Enter a name for the new server role, or view the name of the role being edited.

 

Owner

Select an owner from the drop-down list of logins.

 

Members of server role

Add members to the role, i.e. add logins that will inherit the permissions of the role.

To add a login, you need to move it from the Available Principals list to the Selected Principals list. Use the MoveAllToAvailable MoveToAvailable MoveToSelected MoveAllToSelected buttons or drag-and-drop operations to move the users from one list to another.