Is there a way to get JBoss JDBC connections to assume a specific user possibly from the principle? In many client/server systems a databases built in logging is used to track who initiated an action.
In EJB systems there is not a one to one relation between a connection and a user so using database transation logging is crippled. Most databases allow a connection to temporarily assume a user. Is there a way to configure JBoss to make connections assume their current user/principle?