Configuring process app security

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 cluster_config.json file. You can configure app security using the app_security_mode setting. Below is an overview of the possible values of the app_security_mode setting.

Note:

It is recommended to use the system_managed option.

Value	Description
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. Note: This requires SQL Authentication on the Process Mining data warehouse SQL Server.
single_account	One account is created that is used for all process apps. Note: This means that when editing transformations in Process Mining, users can query data from other process apps.

Enabling system_managed Process Mining data warehouse SQL Server

You need the following permissions on the Process Mining data warehouse SQL Server to enable per app security.

Server role: securityadmin or MS_LoginManager. See the official Microsoft documentation on Fixed server-level roles.

Database-level roles: db_securityadmin and db_accessadmin.

See the official Microsoft documentation on Database-level roles.

Steps

1. Turn on SQL Authentication for the Process Mining data warehouse SQL Server. See the official Microsoft documentation on 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.