How to grant a Windows user or group access to a database (Enterprise Manager)

How to Install SQL Server 2000

How To

How to grant a Windows user or group access to a database (Enterprise Manager)

To grant a Windows NT 4.0 or Windows 2000 user or group 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 user or group will be granted access.

  3. Right-click Users, and then click New Database User.

  4. In the Login name box, type or select the Microsoft® Windows NT® 4.0 or Windows® 2000 user or group name 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 to be granted to the user or group in addition to public, the default.

See Also

Granting a Windows NT User or Group Access to a Database