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

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, and then expand a server.
   
   
2. Expand Databases, and 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, and then click a user or users to add.

   Only users in the selected database can be added to the role.

See Also

Adding a Member to a Predefined Role

Adding a Member to a SQL Server Database Role