Online Documentation for SQL Manager for SQL server

Creating/editing role

Use the Role 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.

Role type

Select whether the preferable role type:

Standard (user-defined) role

Application role

If a Standard role is being created/edited, you should 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 Users list to the Selected Users list. Use the buttons or drag-and-drop operations to move the users from one list to another.

An Application role is a database principal that enables an application to run with its own, user-like permissions. You can use application roles to enable access to specific data to only those users who connect through a particular application.

If an Application role is being created/edited, you should specify a password for the role.

Default schema

Specify the first schema that will be searched by the server when it resolves the names of objects for this role.

Note: If this field remains <Default>, the application role will use DBO as its default schema. The schema defined may  not exist in the database.

Note that in the Database Explorer different icons are used for Application role and User role.