Configuring process app security

Configure process app security modes for Process Mining on Automation Suite on OpenShift.

To restrict the data users have access to when editing transformations, you can set the process app security type for Process Mining process apps in the input.json file. You can configure app security using the app_security_mode setting.

Note:

It is recommended to use the system_managed option.

system_managed (default)

A SQL user is created automatically per process app. This ensures that users editing transformations in Process Mining can only query data that belongs to the process apps for which they have edit permissions. Passwords are rotated on every use.

This requires SQL authentication on the Process Mining data warehouse SQL Server. The SQL user used in the connection strings to connect to the AutomationSuite_ProcessMining_Warehouse database must have at least the following roles, both during and after installation, to enable per-app security:

• Server role: securityadmin or MS_LoginManager. For details, refer to Fixed server-level roles.
• Database-level roles: db_securityadmin and db_accessadmin. For details, refer to Database-level roles.

single_account

One account is created and used for all process apps. This means that when editing transformations in Process Mining, users can query data from other process apps.

The SQL user used in the connection strings to connect to the AutomationSuite_ProcessMining_Warehouse database must have at least the following database-level roles and permissions, both during and after installation, to enable per-app security:

• Database-level roles: db_securityadmin and db_accessadmin. For details, refer to Database-level roles.
• Read/write access: On schema, tables, and views.

Steps

1. Turn on SQL Authentication for the Process Mining data warehouse SQL Server. For details, refer to Change server authentication mode.
2. Grant ALTER ANY LOGIN to the provisioning user of Process Mining.
3. Grant access to the master database to the provisioning user of Process Mining.
   Note:

   The SQL user used in the connection strings used to connect to the master database must have enough permissions to create login, users and roles.