Is it possible to use Oracle proxy authentication in CMP-EJB application?
To be more concrete:
1. There is a special DB - proxy user.
2. There is a connection pool on Glassfish. This pool is configured to create connections to DB on behalf of that proxy user (using his username and password).
3. When the end user starts his ACC-application, Glassfish authenticates that user.
4. When end user's application access database using EJB, I need to pass that end user's identity (username or LDAP's DN) to DB. Every end-user has Oracle privelege "grant connect through <proxy-user-name>"
Is it possible to configure connection pool to support such reauthentication?
[Message sent by forum member 'cvoronin' (cvoronin)]
http://forums.java.net/jive/thread.jspa?messageID=273058