I want to use hibernate with an existing database. The problem is that there are multiple database accounts with different privileges, and my application must dynamically switch to the appropriate database user based on what it is doing and for whom? At the JDBC level, I want to be calling getConnection passing in a database username and password. How can I communicate these values to the Hibernate DAO?

Thanks,
Dennis

Sounds like you need to create multiple session factories with different username/password configs. Then choose the session factory appropriate for your user/operation in your DAO.

I'm also interested in this, mainly in the JPA context.

There is the DataSource.getConnection(username, password) but when using JPA, is there any way of doing a run-time change of the database user?

EntityManagerFactory has a setPersistenceUnitProperties(Map) but that is probably at too high a level(?)

aTdHvAaNnKcSe,
-Nik