How to create a database user in Microsoft SQL Server?

Follow the steps given below to create a database user in SQL Server Management Studio:

1. In Microsoft SQL Server Management Studio, open Object Explorer and expand the Databases folder.
2. Select/ Expand the database in which to create the new database user.
3. Right-click the Security folder, point to New, and then click User.
4. On the General page, enter a name for the new user in the User name box.
5. In the Login name box, enter the name of a SQL Server login to map to the database user.
6. Click OK.

Tags: Microsoft, Database, SQL Server

Related