Export (0) Print
Expand All
Expand Minimize

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

SQL Server 2000

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft