We plan to use EJB. In the previous applications we used Oracle DB with oracle specific database security features where every user used to have his own connection, with specific permissions and so on...
Is there any way to use multiple database users (each user opens it?s own db connection) and BMP or CMP? My colleagues argue that there should be a way. I think there is no any way because entity beans are independent of user sessions and all BMP beans should work using the same predefined user.
I think the only way to implement this is to use session beans only but this will hurt performance, scalability and so on...
One more question: Is there any way to encrypt db user?s password in xml files?
