X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 27F8C47595A for ; Mon, 3 Mar 2003 12:49:56 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 65725-06 for ; Mon, 3 Mar 2003 12:49:54 -0500 (EST) Received: from one.kreator.com (one.kreator.com [213.187.162.222]) by postgresql.org (Postfix) with SMTP id 0BCAA475925 for ; Mon, 3 Mar 2003 12:49:54 -0500 (EST) Received: (qmail 28940 invoked by uid 1000); 3 Mar 2003 17:49:59 -0000 Message-ID: <20030303174959.29713.qmail@one.kreator.com> From: "Aasmund Midttun Godal" To: "pgsql-sql@postgresql.org" Subject: Suggestion: set session authorization with password Date: Mon, 03 Mar 2003 18:49:58 +0100 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/81 X-Sequence-Number: 12121 Hi! Today, it is only possible to switch effective user if you are superuser. If it would be possible to switch the user with password, it would make a lot of applications (which use persistant connections) faster and more secure. Regards, Aasmund Midttun Godal aasmund@godal.com - http://godal.com +47 40 45 20 46 - Stadsing. Dahlsgt 34, N-7043 Trondheim