Online Documentation for SQL Administrator for SQL Server

Server Roles


The Server Roles section allows you to browse and edit the list of SQL Server Roles, and to define login membership for each role.

 

Use the context menu to:

Create create a new server role

Edit edit the selected server role(s)

Drop drop selected server role(s)

  • rename the selected server role
  • create the object copy on the same server
  • clone the object copy to another server

SetMembers set members of the role

  • remove all members from the role

Print create and print the report

 

Security - Server roles

 

 

The upper list displays the server roles as a grid with the following columns: Server Role Name, Number of Members, Server Role Description. If more convenient, you can change the order of the columns by dragging their headers horizontally. See the Working with grid section of the SQL Administrator documentation to find out operations that can be performed with the grid.

 

If you choose a Set Members... item of the context menu the following window appears.

 

Server Roles - Set Server Role Members

 

 

To set a member of the selected server role choose it among the list of logins and check the corresponding box.

For your convenience the Select All and Unselect All functions are implemented in the context menu of the members list.

 

The lower area allows you to define login membership, i.e. to select the logins that will belong to the selected server role. The Server Roles determine the tasks that can be performed through the selected login. You can edit any login by double-clicking its alias.

 

 


See also:

Logins

Database users

Database roles

Application Roles

Server Permissions

Database Permissions