How to create a SQL Server database role (Enterprise Manager)

To create 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 to create a role.
   
   
3. Right-click Roles, and then click New Database Role.
   
   
4. In the Name box, enter the name of the new role.
   
   
5. Optionally, click Add to add members to the Standard role list, and then click a user or users to add. 

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

See Also

Creating User-Defined SQL Server Database Roles