Have a question on how user credentials are passed in workflow when publishing to gallery.
User has created workflow with an ODBC data input using their username and password. That workflow is then published and shared with other artisan users.
1. When run in gallery, the username and password created in the workflow is used to connect to ODBC connector.
2. If workflow is downloaded by any of the users that have been shared workflow, the publisher's credentials are still in the workflow.
Is there any way to prevent this (with server setup, not workflow tools), so that whoever is running the workflow needs to enter their credentials.
Hey @ptbui15
If you have an ODBC connection on an input tool that looks like DSN=blah blah blah then you are correct that when it is published to the gallery it uses the username and connection specified in the connection string. In addition when downloading that workflow it still retains the connection details (although encrypted). So I User B can be running workflows use User A's credentials.
To get round this there are 2 options.