The CREATE USER Command in SQL Server

The CREATE USER Command in SQL Server is easier to understand when the core ideas are paired with practical examples. The sections below explain the topic clearly, highlight useful steps, and point out details that can prevent common errors.

You will show you in detail how to use the CREATE USER command in SQL Server, with specific syntax and examples to better visualize and capture commands.

Describe the CREATE USER command in SQL Server

CREATE USER creates the user database to log into SQL Server. A user database will be mapped to the Login, identifier used to connect to a specific SQL Server instance.

The syntax of CREATE USER command in SQL Server

The CREATE USER command has the following syntax:

 CREATE USER user_name FOR LOGIN login_name;

Parameters:

user_name: The name of the database user you want to create.
login_name: The Login name helps connect to a specific SQL Server.

Note:

Before creating a database user, make sure you have created the Login before.
You can only map a Login to a user in each database in SQL Server, but you can also map Login to different user names for each database as long as it is a 1: 1 relationship of Login with a single database.

Example of CREATE USER command in SQL Server

Next lesson: Change the password in SQL Server

FAQ

What should you know about describe the CREATE USER command in SQL Server?

CREATE USER creates the user database to log into SQL Server. A user database will be mapped to the Login, identifier used to connect to a specific SQL Server instance.