Hi,
I want to migrate a legacy database that is on top of a set of views in Oracle.
Part of the security is now based on the database user login. Is this also possible in the Cuba-framework?
So can I use the user/password to login to the database also?
Regards,
Juan-José.
Hi Juan-José,
Unfortunately you cannot use user’s login/password to connect to the database in a CUBA application, because all connections are interchangeable and stored in a common pool.
Hi Konstatin,
Would it be possible to use de db-per-tenant solution? Each tenant/user has it’s own database connection used with it’s own user credentials? Then each user is logged in with the database user/password and then the legacy stuff based on user-id can still work correctly.
Do you think that is an option?
Regards,
Juan-José
Ok, maybe this is a bad idea. The thing is that there are some views using the sys_context(‘userenv’,'session_user) to filter some content.
Would it be possible to set a sys_context(‘cuba’,'user) and pass the Cuba-platform user to the database?
Maybe in the way done in this blog: Set values for bind parameters in a database view using application context - single round-trip context manipulation and querying - AMIS, Data Driven Blog - Oracle & Microsoft Azure
By rewriting/prefixing the select query’s sent to the database?