Hi Community!
We have a question about the best practices for connecting to data sources that have row-level security. Usually, this security is being inherited from Active Directory groups that have been set up.
An example of this is with our EMEA processes. We may want a leader from the UK to run the workflow and get results and data for their country, whereas a leader in Dubai should only see their piece, and then our regional leaders would be able to see all of the EMEA regions - ideally all running the same workflow.
Currently, we have data connections set up for these data sources but probably need to explore other ways to connect to these data sources so that the run-as user is taken into consideration when pulling in the data. We also want to make sure we have:
- A clean way for users to connect to the data source when developing workflows in Designer (not embedding it themselves)
- The administration side of it is fairly simple - nothing where we have to update individual workers each time a connection needs to be added or changed.
Let me know if you have been able to accomplish something like this before, and how you went about it. Appreciate the help!
