Username and Password in Project Settings

BNitsche

Hi,
we have one development Database and all developers work with this database and not a local database. Is it possible to store the username and the password in the project config file flyway-dev.json?

The password should not be stored as plain text

This would eliminate the step that a user has to enter a user and a password when a new project is opened for the first time

Peter_Laws

Hello,

Thank you for the question. No I'm afraid not, that's why the default credential store is used, to avoid the potential insecurity you're referencing here.

I haven't how opportunity to test it, but assuming a secrets manager* defined in the connection string were honoured (I think it should be) would that suit your organisation's needs?

*https://documentation.red-gate.com/fd/secrets-management-184127477.html

BNitsche

Hello,

as far as i understand this is a feature of the enterprise edition, we have the teams edition

Peter_Laws

In which case I'm afraid not, the expectation is that each participant will have to authenticate once.