How to: Create a Database User

1. In SQL Server Management Studio, open Object Explorer and expand the Databases folder.

2. 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.

1. In Query Editor, connect to the database in which to create the new database user by executing the following Transact-SQL command: USE <database name> GO

2. Create the user by executing the following Transact-SQL command: CREATE USER <new user name> FOR LOGIN <login name> ; GO

Concepts

Other Resources

Help and Information