How to: Create a Database User

New: 17 July 2006

This topic shows how to create a database user mapped to a SQL Server login. The topic assumes that a corresponding SQL Server login already exists. For information about creating a SQL Server login, see How to: Create a SQL Server Login.

To create a database user using SQL Server Management Studio

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.

To create a database user using Transact-SQL

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

See Also

Concepts

Principals

Other Resources

CREATE USER (Transact-SQL)
sys.database_principals (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance