logs to database with own credentials

[marx3]

Hello
Is it possible to configure JBoss, so every user would login to database with his own username/password, or even better, with certificate?
It seems it would cause making different connection pool for every logged in user - I would like to know if it's possible.
If not - I would like to know if it's possible to modify part of JBoss to do that.

[marx3]

I've found: PoolBySubject. Am I right it's what I want?

[vickyk]

"Marx3" wrote:
I've found: PoolBySubject. Am I right it's what I want?

Yes you can configure JbossManagedConnectionPool to use PoolBySubject Or PoolByCri .
The username/password can be either be passed as parameter to getConnection(...) Or can be taken from the the subject .
For the former usage you need to configure <application-managed-security> and for the later you would need to define <security-domain> pointing to the login module to be used , look here for more details about security-domain configuration
http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigJCALoginModule