Online Documentation for SQL Administrator for SQL Server

Setting database role properties

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

Name

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

Owner

Select a database owner from the drop-down list.

Members of the role

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

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