How to create an application role (Enterprise Manager)

To create an application 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 application role.
   
   
5. Under Database role type, click Application role, and then enter a password.

See Also

Establishing Application Security and Application Roles