Hello,
I have to activate a password-secured oracle role in sessionFactory.openSession(). How can I achieve this?

Thanks in advance,

Matthias

as to my knowledge hibernate does not provide an event/interceptor for something like onSessionCreation().

It would be nice to overwrite SessionImplementor and provide the class thru hibernate-config. But I'm afraid that's not supposed to be a pattern also.

So, I guess you need to check out the hibernate sources and patch org.hibernate.impl.SessionImpl.java
good luck ;)