How to grant a SQL Server login access to a database (Enterprise Manager)

To grant a SQL Server login access to a database

1. Expand a server group, and then expand a server.
   
   
2. Expand Databases, and then expand the database to which the login will be granted access.
   
   
3. Right-click Users, and then click New Database User.
   
   
4. In the Login name box, click the Microsoft® SQL Server™ login to which database access will be granted.
   
   
5. Optionally, in User name, enter the user name that the login is known by in the database. By default, it is set to the login name.
   
   
6. Optionally, select database role memberships in addition to public, the default.

See Also

Granting a SQL Server Login Access to a Database

guest User