Hi,

I'm starting to use Oracle OID (LDAP like) so as I can audit database access by system user and not by (a single) database user. But to accomplish this I need to send a username/password to the ConnectionPool (or set in the connection, if possible) each time a user makes the login on my application. It's necessary so as the OID knows who's executing the SQL so as it can audit it's access.

To clarify: Using Oracle OID I can connect my application to the database via a single database/global user, but to audit each different user it asks for it to personally login on it by taking it's credentials.

What I need is something like this:

hibSession = factorySession.openSession(USERNAME, PWD);

So, my question is: is it possible?

Thanks a lot!

Expedito (Brazil)

don't you just want to set these properties on the connection?

you can get the jdbc connection from the session with

Implement a custom ConnectionProvider.