I guess I could use any implementation of a connection pool for a simple implementation. I just need to use a connection pool for every user (of course using a smaller number of connections than usually). The connection pool object will be created only when the user logs in (if it doesn't exist already). Maybe it would be nice however to return the first connection quickly and then create the others in a background thread. Since there could be a lot of users I should have a max-connection-pools config-param. When is reached I will remove the connection pools of user's who haven't used the object recently.
But if there is no implementation of this already, probably this is a not so good idea after all :-). That's why I asked on the list before I want to use it. Tamas On Wed, 2005-07-06 at 21:40 -0600, Larry Meadors wrote: > I do not know of any, but it is possible to create one using something > like proxool. > > Larry > > On 7/6/05, Tamas Szabo <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I have a question regarding connection pools and DB user rights. > > > > When you use connection pool objects you specify an user who will be the > > owner of all the Connection objects in the pool. > > I guess that the most usual case is to specify an user which has the DB > > permissions to execute all the DB operations that needs to be executed > > from the application. You also create users, add them to roles. > > The users login to the application and authorization is configured for > > the parts of the application, but underneath all the users use > > connections with rights to execute all the DB operations. > > > > I don't want to create users and roles in my webapp. I would like to > > allow the user to enter a real DB/password which I want to use to make > > the DB connection so the rights of the user to make a given DB operation > > will be configured in the DB. > > > > Is there a support for this or am I on my own to implement a solution > > for it? > > > > Thank you, > > > > Tamas > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
