Feature: Implement Home Realm Discovery (HRD) for Database Connections
Description: Currently, when a user logs into an application that supports multiple database connections, the system defaults to the first connection to authenticate the user. If the user exists in a different database connection, the system fails to locate the user, causing login issues. We propose implementing HRD for database connections similar to how it functions in enterprise connections. HRD would intelligently route the login request to the appropriate database connection based on the user’s email domain or a custom logic, ensuring a seamless user authentication experience.
Use-case: We are onboarding customers with multiple database connections linked to a single application. This feature would ensure that users are authenticated correctly, regardless of which database connection they reside in. It would enhance user experience by eliminating the need to manually select the correct database connection or risk login failures, streamlining the process for both users and administrators.