User authentication on the application server through authentication in the databaseAsked byamy romanoski
The situation is as follows:
There is a product based on an Oracle database. Authentication and authorization of users occurs by usernames / passwords of database users. All the logic of the system lies in the database.
On the application server (hereinafter referred to as SP) (GlassFish 3), a JDBC resource is configured to access the database (no login / password is specified).
Is it possible to achieve the connection of the joint venture user with the resource user in a declarative way?
The task is to do pass-through authentication with minimum coding.