Ramifications of deleting Username-Password-Authentication?

Hello! I am wondering if delete my Username-Password-Authentication database (in the Danger Zone), what I can expect to happen to my Application, Forms, Triggers and Actions? Should also click the toggle “Applications using this connection” before deleting? So my Application isn’t being used by the database any longer? Thank you!

Hello @joaquinvaldezhs,

By deleting the Username-Password-Authentication database all users and functionality relying on that specific username/password database will cease to work, so the best practice would be to first navigate to the database connection’s settings and disable it for all applications listed under the “Applications using this connection” tab.

May I also ask what would be the reason for completely deleting the database ? I am asking this since the difference between disabling the default database for specific applications and deletion is significant:

  • Disabling: Removes the connection option from the application’s login flow but retains the database and its users (in case you need to re-enable it later)
  • Deleting: Permanently deletes the connection and all associated user data (users who only existed in that database). This action is irreversible.

As far as how different functionalities of your tenant will be affected it is expected that:

  • Any application that is enabled for this connection will immediately lose the ability for users to log in, so any existing user whose account was stored in this deleted database will no longer be able to authenticate via username/password.

  • If your application is configured to use other connections (like social logins, enterprise connections, or a different database connection), users who use those methods will be unaffected.

  • General **Triggers/Actions/Flows will continue to run, as they are activated by the event of successful authentication, but this depends if you are already using another database connection ( since otherwise actions such as Post-user-Registration will not take effect )

I hope this helps, and if you have other questions please let me know!
Thank you,
Remus

Thank you @remus.ivan ! Ideally, I wish I easily could clear the users in my data connection. I have 6k users defined and deleting them manually would take a while.
Disabling means click the toggle for My Application? And if I disable the database I could create a new one?

Thanks,
Joaquin

Hi @joaquinvaldezhs,

You are welcome and thank you for your clarification!

That is correct! It means disabling the applications that are connected to your current database.

This is also true!

Either by disabling or deleting the current database, you will be able to create a new one for your following user store, it is just that by not deleting it you will not completely lose the users’ record, just in case.

Here are the steps for Setting Up Database Connections.

Hope this helps!
Best regards,
Remus

1 Like