Users Wizard (SQL Server)
Go Up to Microsoft SQL Server Object Wizards
The User Wizard lets you create a user who will then have access to the database where you are registering him or her. You can also identify the appropriate user group and the system privileges you want to assign to the new user.
To create a new user using a wizard:
- Open a creation wizard for a user. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - Users (SQL Server) - Properties.
- Roles panel - Users (SQL Server) - Roles.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object.
Users (SQL Server) - Properties
When creating or editing a user, this tab/panel lets you work with the following settings:
Setting | Description |
---|---|
Login Name |
Select the server login associated with this user. |
Name |
Provide the user name. |
Users (SQL Server) - Roles
For each role to be assigned to the user, select the check box beside that role.