Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: User privileges in web database applications
- From: John DeSoi <desoi(at)pgedit(dot)com>
- To: Tim Hart <tjhart(at)mac(dot)com>
- Cc: "Antonis Christofides" <anthony(at)itia(dot)ntua(dot)gr>, <pgsql-general(at)postgresql(dot)org>
- Subject: Re: User privileges in web database applications
- Date: Fri, 30 Jun 2006 09:44:56 -0400
On Jun 29, 2006, at 5:58 PM, Tim Hart wrote:
I'm coming in a bit late to this conversation, so forgive me if I've missed something. Isn't this problem the reason that connection pools were created?In a connection pool, connections are only associated with a particular user for the duration of a transaction. Once the transaction is complete,the connection goes back to the pool.
Right, this is standard operating procedure. But the original poster mentioned tying the connection to a particular web user/session. In other words, one connection per user.
John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
- Follow-Ups:
- Re: User privileges in web database applications
- From: Antonis Christofides
- Re: User privileges in web database applications
- References:
- User privileges in web database applications
- From: Antonis Christofides
- Re: User privileges in web database applications
- From: John DeSoi
- Re: User privileges in web database applications
- From: Tim Hart
- User privileges in web database applications
- Prev by Date: Re: pg_restore: [archiver] could not open input file
- Next by Date: Re: Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4
- Previous by thread: Re: User privileges in web database applications
- Next by thread: Re: User privileges in web database applications
- Indexes: