I've got a requirement for our new product in that every transaction with the database (ie connection) should be opened to the database as that user.

Right now I have a datasource defined in mssql-ds.xml that specifies a specific user. How can I make this dynamic?

Has anyone else had to do this?

I am using the MBean for Hibernate as this article says, http://www.hibernate.org/66.html

Thank you,
David

Hm, you will have to write your own HibernateService MBean to wire it up. This is called "proxy authentication", by the way. No, I don't know how to do it. I'd use a custom ConnectionProvider if Hibernate wouldn't run as an MBean.