How to set up "multi-user" using Spring hikariCP?

Question

Oracle

There is a basis on 12, each user comes under the login with the rights.
All logic is built on stored procedures/functions.
The question arose of writing a REST API for this server, but with the condition that each user will log in under
his oracle account.
Is it possible to configure hikaricp (or something similar) so that it creates its own connection pool at runtime for each connected user with his login / password?

Answer 1

Found a solution.
What I need is called Multitenancy.
https://www.baeldung.com/hibernate-5-multitenancy
https://bytefish.org/blog/spring_boot_multitenancy/
https://www.citusdata.com/blog/2018/02/13/using-hi..
https://habr.com/ru/post/110979/ https://habr.com/ru/post/252353/ _