I want to have multiple hikari cp connection pools for same database as usual.
Then I would like to isolate these connection pools against specific user logins (which ofcourse by using the user attributes available in http request)
How to dynamically implement this in spring. (I am not having conceptual understanding how spring autoconfiguration handles the incoming requests and assigns the db connection pools)