how to connect to a schema based on user
843859May 5 2010 — edited Nov 20 2014In our web application we connect to the database using context.xml.
So a user log on we read the context file and connect to the specific schema.
Now, we have a requirement to have a schema per user group.
I appreciate any idea on how to do the above. I am thinking of having a schema that uses the context file, in it I have a table with all parameters needed to have a new connection for the user. is that a sound logic.