How to create a SQL Server database role (Enterprise Manager)
To create a SQL Server database role
- Expand a server group, and then expand a server.
- Expand Databases, and then expand the database in which to create a role.
- Right-click Roles, and then click New Database Role.
- In the Name box, enter the name of the new role.
- 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.