How to create an application role (Enterprise Manager)

To create an application role

1. Expand a server group; then expand a server.
2. Expand Databases; then expand the database in which to create a role.
3. Right-click Roles; then click New Database Role....
4. In Name, enter the name of the new application role.
5. Select Application role, then enter a password.

See Also

Application Security and Application Roles