We use a lot of applications with dedicated user and roles.

In that particular case, since the account should only have access to that specific DB, we do default to the specific DB as default.

For other "management" accounts, we default to master. We identified this issue a long time ago - the hard way like many - and without really thinking about it, we adopted this method. If your DB is down, the application that requires it will be down, which is really easy to spot 🙂

Thanks for the good explanation.

Olivier