Permissions Required for SQL Server Users for Dashboard

This section explains how to create users in SQL Server Database, assign roles, and grant permissions to them depending upon whether they must be allowed to create and update the Innowera Dashboard database using the Innowera Dashboard Database Setup tool.

• Advanced users are users with db_creator server-level role assigned to them. In this section, advanceduser is an example of such a user. If the product name here database is already created, then a user with db_owner database-level role will suffice.
• Basic users are users with only the db_datareader and db_datawriter roles assigned to them in addition to EXECUTE permission. Such users can perform only insert, update, delete, and select operations from the product name here web application. In this section, basicuser is an example of such a user.

To create a user and grant permissions,

1. Connect to the appropriate SQL Server using SQL Server Management Studio.
2. Right-click Logins, and select New Login.
3. Provide the login name in the Login name box. You can select Windows authentication or SQL Server authentication. For example, enter advanceduser as the login name to create the advanceduser user.
4. For the advanceduser perform the following steps:
   1. In the Object Explorer, expand Security > Logins.
   2. Right-click advanceduser, and select Properties. The Login Properties-advanceduser window is displayed.
   3. Select Server Roles in the left pane and in Server Roles section, select db_creator. The required role is assigned to the advanceduser.
5. Repeat steps 1 to 3 to create the basicuser, and perform the following steps:
   1. In the Object Explorer, expand Security > Logins.
   2. Right-click basicsuser, and select Properties. The Login Properties-basicuser window is displayed.
   3. Select User Mapping, and select the database that was created using the Innowera Dashboard Database Setup tool from the list of databases that are displayed in Users mapped to this login section. For example, if INW_DASHBOARD is the name of the database that was created using the tool, select INW_DASHBOARD database in the section.
   4. In the Database role membership for: INW_DASHBOARD section, select db datareader and db datawriter.
   5. In the Object Explorer, expand Databases.
   6. Right-click INW_DASHBOARD, and select Properties. The Database Properties-INW_DASHBOARD window is displayed.
   7. Select Permissions in the pane on the left side and in Permissions for basicuser section, select Execute and Alter. The required roles and permissions are assigned to the basicuser.

Important: After the advanceduser creates the Innowera Dashboard database using the Innowera Dashboard Database Setup tool, we recommend that the basicuser use the tool to perform other operations, if required. Additionally, if the basicuser is using Process Runner, Process Runner DB, or Process Runner Excel Add-in service configuration option, then the ALTER TABLE permission must also be given for the dbo.Stat table. If you want the basicuser to use the archive database feature and export the logs to a file, ensure that the sysadmin role is also assigned to this user