Disable ability to saved login info when connecting to database from dynamic input tool

[amlrcd]

My team uses shared workflows that everyone has access too and a frequent problem we have is when someone tries to run a workflow with incorrect login details for the database we are using in the dynamic input selection ( i.e. another users login ID and password is saved and when someone else runs the work flow with out changing , then the other user gets locked out of their computer due to the other user trying to run the work flow with their login details). 

Is there a way to prevent the login info being saved to the workflow? I.e. when someone opens the workflow , they have to login every time.  I know one solution would be saving the workflow to that users desktop after update login details but curious if there are any other ideas to prevent this from happening. 

Thanks! 

[geraldo]

@amlrcd 

the ideal is to create a connection with the same DNS (ALIAS) on the local machine and Server through the Alteryx option

Options-> Advanced Optionsn-> Manage Data Connections or Manage In-Db Connections
and use the Saved Data Source option
AKA:

Or disable item 9 of dynamic input

[apathetichell]

As @geraldo notes - just use IN-DB - and mandate a group wide naming convention for the database. Users will store credentials in their ODBC 64 on their specific machines and the In-DB will adjust based upon the specific user/machine it's run on.