Online Documentation for SQL Manager for SQL server

Creating/editing user


Use the User tab of User Editor to create/edit a user and specify its properties.

 

User Editor - Editing user definition

 

RadioButton Login

If this option is selected, use the drop-down list to specify the SQL Server login for which the database user is being created.

 

RadioButton Windows principal

Check this option to specify the Windows principal for which the database user is being created. The Windows principal can be a Windows user, or a Windows group. The user will be created even if the Windows principal does not have a login. When connecting to SQL Server, if the Windows principal does not have a login, the Windows principal must authenticate at the Database Engine through membership in a Windows group that has a login, or the connection string must specify the contained database as the initial catalog.

 

CheckBox Local account on server

Select this option to specify a built-in server account for the user, or specify the Windows Domain. After that specify User/group name in the corresponding field.

You can select whether a new user will be created in a RadioButton User/custom group or in a RadioButton Built-in group.

 

RadioButton Certificate

If this option is selected, use the drop-down list to specify the certificate for which the database user is being created.

 

RadioButton Asymmetric key

If this option is selected, use the drop-down list to specify the asymmetric key for which the database user is being created.

 

RadioButton Without login

This option specifies that the user should not be mapped to any of existing logins.

 

User Name

Specifies the name by which the user is identified inside this database.

 

Default schema

Use the drop-down list to specify the first schema that will be searched by the server when it resolves the names of objects for this database user.

 

Default language

Specify the default language for the new user. If no default language is specified, the default language for the user will be the default language of the database.

Note: Default language can be specified only for contained database users.