Permissions Required for SQL Server Users for Easy Workflow

This section explains how to create users in a SQL Server Database and grant permissions to them depending upon the tasks that they must perform in Easy Workflow.

• Basic users are users who typically perform tasks using the Process Runner Excel Add-in, such as creating workflows, approving or rejecting work items, and creating reports. Basic users can also use the IEWF Configuration Tool to only map the database to the service. In this section, basicuser is an example of such a user.
• Advanced users are users who can archive the Easy Workflow database using the IEWF Configuration Tool or from the Easy Workflow Cockpit. In this section, advanceduser is an example of such a user.
  • If the Easy Workflow database is already created, then the db_owner database-level role suffices for the user.
  • If the user must create or update the Easy Workflow database, then the dbcreator server-level role must be assigned to the user.
  • If the user must clear the database cache using the tool, then the serveradmin server-role must be assigned to the user.

To create a user and grant permissions,

1. Connect to the appropriate SQL Server using SQL Server Management Studio and create two users, basicuser and advanceduser. For information about how to create the users, see the Microsoft SQL Server documentation.
2. For basicuser, perform the following steps:
   1. In the Object Explorer, expand Security > Logins.
   2. Right-click basicuser and select Properties. The Login Properties - basicuser window is displayed.
   3. Select User Mapping in the left pane and select the database that was created using the IEWF Configuration Tool from the list of databases that are displayed in the Users mapped to this login section. For example, if you have not edited the default name of the database, INW_EWFDB, that was created using the tool, select INW_EWFDB database in the section.
   4. In the Object Explorer, expand Databases, and select INW_EWFDB.
   5. Right-click INW_EWFDB, and select Properties. The Database Properties-INW_EWFDB window is displayed.
   6. Select Connect and Execute permissions.
3. Similarly, for advanceduser, select the following permissions:
   • Connect, Execute, Select, and Delete for the INW_EWFDB database.
   • Connect, Execute, Select, Insert, and Alter for the INW_EWFDB_Arc database.

You can now use the basicuser and advanceduser to perform the different Easy Workflow tasks.