Setting User Credentials for Validation only

[Dominik2806]

When saving a workflow to the gallery, none of the options I could choose from Set workflow credentials validates a workflow successfully when using database connections due to missing permission on the server (No specific Run As is configured on the Server). Apparently the server validates the workflow as following:

User is not required to specify credentials:No possibility to add credentials when running the workflow on the server. In that case, the workflow validates database connections with errors due to missing permission on the server. This error was expected.

User must specify their own credentials: This option is the most appropriate in case of working with database connections with regard to our use cases and security policies. Unfortunately this option is only enabled when the workflow is saved on the server already and run from the gallery. In case of the validation step when saving the workflow to the gallery, the server evaluates with the system user of the server. As a result, the validation fails. In that case, I expected the server to run the validation with the user from the Alteryx Designer.

Always run this workflow with these credentials: This option is not appropriate in terms of our security policy, since the workflow is permanently set with the users credentials.

So my suggestion would be to:

• Prompt dialog to enter my credentials for validation once or
• The server runs the validation with the User from Designer, where the workflow is going to be saved from.

Otherwise is see no benefit of the validation feature (with respect to our use cases and security policies)

[NicolasSz]

Hi,

This is a great idea ! What is the workaround at the moment to disable the validation step for all users ? I dont want to ask my user to keep in mind to untick the box everytime they save a workflow...

Thanks,

[NicolasSz]

Any suggestion ?