Re: User privileges in web database applications - Mailing list pgsql-general

From John DeSoi
Subject Re: User privileges in web database applications
Date
Msg-id 5C816A7C-9F58-4133-B46D-C6223E3657B7@pgedit.com
Whole thread Raw
In response to Re: User privileges in web database applications  (Tim Hart <tjhart@mac.com>)
Responses Re: User privileges in web database applications  (Antonis Christofides <anthony@itia.ntua.gr>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: pg_restore: [archiver] could not open input file
Next
From: Tom Lane
Date:
Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4