Creating Workflow Application Users

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

When you have created the Microsoft® Windows® 2000 accounts, Microsoft® SQL Server™ logins, and database roles for your users, then you can assign the users to your workflow application. While the SQL Server login makes it possible for the users to connect to the SQL Server system, a database user account is required to access individual databases. These user accounts are created within each workflow application and are unique to each application.

You create workflow application database users with SQL Server Enterprise Manager.

To create a workflow application user

1. From the Start menu, point to Programs, then Microsoft SQL Server, and then click Enterprise Manager.
2. Expand a server group, and then expand a server.
3. Expand the databases group, and then expand a particular database.
4. Right-click User, and click New Database User.
5. Select a login name from the list.
6. If you wish to designate role membership, enable the roles for the user.
7. You can select properties on a specific role if you want to add other roles to this role or view and modify the permissions for this role.
8. Click OK.

Repeat these steps as required to create additional database users.

See Also

Setting Up Accounts, Logins, Roles, and Users | Security Categories in Workflow Designer for SQL Server | Windows 2000 and SQL Server Security | Creating Database Roles | Assigning Users to Database Roles | Defining Permissions for Database Roles