We are planning to have new application where we are going to have oracle database and here we will have OLS ( ORacle label security ) implemented. Due to this we need to have a connection class which will be responsible for making connection to database based on user credentials . Gere we will have some defined user groups and based on that a given user will be able to login to database from application and will be able to fetch data only those which is supposed to and insert with correct label.
I am looking if soemone can help me a good way of doing this as now we will be needing different credentials .
I can use driver manager here but I am mainly concern about connection pooling as forcing each user to have his own Datbase credential defeats the purpose of having a connection pool .