My company has recently upgraded from 2019.4 to 2021.2 and we are trying to navigate the new requirements to share data connections with all users who run workflows on the Gallery. We have 90 artisans, 300 members who run workflows on our gallery, and 75 data connections. We are trying to figure out how to handle this so we aren't constantly adding users to connections but also avoid the security issue below. has anyone faced this issue?
Security Issue ------------------------------------------------------------------------
User A with Sql connection A that has read/write to Schema A
User B with Sql connection B that has read write to Schema B
Both users are artisans.
User B builds workflow B and shared via collection for User A to run that outputs to Schema B for a specific process, but User B does not want User A to have full access to connection B outside of just being able to run the specific workflow shared in the collection.
How can we share the connections to meet this requirement?
----------------------------------------------------------------------------------------------
I've already read these article and I'm trying to figure out how others have handled this:
Troubleshooting "Unable to translate Alias" with G... - Alteryx Community
https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Sharing-Data-Connections-with-User-Groups-Alteryx-21-2/ta-p/760463
