Choose your database:

Partners

Testimonials

Kevin Settler: "If you need the job done right and on time, do it with MS SQL Maestro on your team. The software is a pleasure for us. SQL Maestro Group do excellent work and are dedicated to producing products that all can be proud of".

Tracy J Powell: "Thank you VERY much for the quick and helpful response. I will definitely upgrade as soon as possible. Your products are great and I use them daily".

Add your opinion

Customers

Become a customer

SQL Maestro Group / Products / MS SQL Server / MS SQL Maestro / Documentation

Download

Buy

MS SQL Maestro online Help

Return to chapter overview

Create User Wizard guides you through the process of creating a new database user. See How To Create User to learn how to run the wizard.

The basic principles of Create Object Wizards in MS SQL Maestro are explained in a separate topic. Below you will find a description of wizard steps that are unique for the current object.

Specify the Name by which the user is identified inside this database.

Note: the name of the object must be unique among all the object names in its container. Moreover, all the objects that are source of data need unique names among themselves. You can use any identifier that is allowed by Microsoft SQL server.

Comment

This field stores a comment to the user.

Type

Indicates the user type. Possible variants are: for login, certificate and asymmetric key. Indicates the respective database object type for which the database user is being created.

For the login user type only. Specifies the SQL Server login for which the database user is being created.

Default Schema

For the login user type only. Specifies the first schema that will be searched by the server when it resolves the names of objects for this database user.

Certificate

For the certificate user type only. Specifies the certificate for which the database user is being created.

Asymmetric key

For the asymmetric key user type only. Specifies the asymmetric key for which the database user is being created.

See also: User Editor

Return to chapter overview

SQL Maestro Group wish you a Merry Christmas!

We're happy to grant you a 20% discount for all our products and bundles till December 31!

Company news

Jul 7, 2023

MS SQL Server Tools Family upgraded

All software of our Microsoft SQL Server family come now with SQL Server 2022 compatibility.

Jun 29, 2017

MS SQL Maestro 17.6 released

New version features support for SQL Server 2017, support for row-level security policies, custom labels and colors for server nodes in Database Explorer, and some other useful things.

Jul 27, 2015

MS SQL Maestro 15.7 released

New version features support for Azure SQL Database and SQL Server 2016, updated data export/import tools, colored tabs, new encryption algorithms in data grids and some other useful things.

More news

Feature of the day

Login management

MS SQL Maestro supports all types of SQL Server logins: Windows Authentication, SQL Server Authentication, Certificate, and Asymmetric Key.

Code Folding

All editors of MS SQL Maestro provide a customizable ability to divide text into logical parts (regions). Each part can be collapsed and extended.

MS SQL Maestro online Help

Create User Wizard

Christmas Sale