Online Documentation for SQL Manager for SQL server

Setting server role parameters


Use the Server Role tab of Server Role Editor to specify server role properties and membership.

 

Server Role Editor - Setting server role parameters

 

 

Name

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

 

Owner

Use the drop-down list to select the owner of the server role (the name of a server login).

 

Members of the role

Add members to the role, i.e. add the logins (or other server roles) that will inherit the permissions of the server role.

To add a login, you need to move it from the Available Principals list to the Selected Princpals list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the logins from one list to another.

 

The role is member of

Define role membership, i.e. select the server role(s) the current server role will be a member of. The selected server roles determine the tasks that can be performed through the current server role.

To select a server role, you need to move it from the Available Server Roles list to the Selected Server Roles list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the roles from one list to another.