How to add a member to a SQL Server database role (Enterprise Manager)

To add a member to a SQL Server database role

  1. Expand a server group; then expand a server.
  2. Expand Databases; then expand the database in which the role exists.
  3. Click Roles.
  4. In the details pane, right-click the role to which the user will be added, and then click Properties.
  5. Click Add...; then click a user or users to add. Only users in the current database can be added to the role.
See Also
Adding a Member to a SQL Server Database Role Adding a Member to a Predefined Role

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.