X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 15CEC9FB2EB
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 11 Sep 2006 09:10:05 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 67031-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 11 Sep 2006 09:09:52 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from wr-out-0506.google.com (wr-out-0506.google.com
 [64.233.184.225])
	by postgresql.org (Postfix) with ESMTP id F39859FB252
	for <pgsql-sql@postgresql.org>; Mon, 11 Sep 2006 09:09:52 -0300 (ADT)
Received: by wr-out-0506.google.com with SMTP id i3so296637wra
	for <pgsql-sql@postgresql.org>; Mon, 11 Sep 2006 05:09:51 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:from:to:cc:subject:in-reply-to:references:date:message-id:user-agent:mime-version:content-type:x-virus-scanned;
	b=HKVPBHDNVwGK1HpZWa4dKjoeSOg4TM4dwyeaEg+sCh8LhfniZ5BCSIOR/PFQxAsXv3isi1zspllnZa+DN0RI3KUd9Bt07ZIaOBhdhWbCuc9opQ7Qwq60CbvXSVtU1/5cNu717QC72t3kL1vYPAw0p80Csl/pftd63lyc0XIOzZM=
Received: by 10.90.115.4 with SMTP id n4mr1474935agc;
	Mon, 11 Sep 2006 05:09:51 -0700 (PDT)
Received: from strongwill.g2ctech ( [200.146.64.254])
	by mx.gmail.com with ESMTP id 66sm3978469wra.2006.09.11.05.09.49;
	Mon, 11 Sep 2006 05:09:50 -0700 (PDT)
Received: from localhost (localhost [127.0.0.1])
	by strongwill.g2ctech (Postfix) with ESMTP id 2AB0FCFEBA;
	Mon, 11 Sep 2006 09:09:46 -0300 (BRT)
Received: from strongwill.g2ctech ([127.0.0.1])
	by localhost (strongwill.g2ctech [127.0.0.1]) (amavisd-new, port 10024)
	with LMTP id 30312-03-2; Mon, 11 Sep 2006 09:09:45 -0300 (BRT)
Received: from jupiter.g2ctech (unknown [10.0.0.240])
	by strongwill.g2ctech (Postfix) with ESMTP id 1AF3FAB58A;
	Mon, 11 Sep 2006 09:09:45 -0300 (BRT)
Received: by jupiter.g2ctech (Postfix, from userid 1000)
	id 0AD67A8689; Mon, 11 Sep 2006 09:09:52 -0300 (BRT)
From: Jorge Godoy <jgodoy@gmail.com>
To: Robert Edwards <bob@cs.anu.edu.au>
Cc: Aaron Bono <postgresql@aranya.com>,  pgsql-sql@postgresql.org
Subject: Re: on connect/on disconnect
In-Reply-To: <4504EB87.3090502@cs.anu.edu.au> (Robert Edwards's message of
	"Mon, 11 Sep 2006 14:52:23 +1000")
References: <4504B474.9010801@cs.anu.edu.au>
	<bf05e51c0609102128u7a6d98e3g9faf634a71736bd@mail.gmail.com>
	<4504EB87.3090502@cs.anu.edu.au>
Date: Mon, 11 Sep 2006 09:09:52 -0300
Message-ID: <87fyeyzjsf.fsf@gmail.com>
User-Agent: Gnus/5.110006 (No Gnus v0.6) Emacs/21.3 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: amavisd-new at g2ctech.com
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.92 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, RCVD_IN_NJABL_PROXY, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200609/67
X-Sequence-Number: 26278

Robert Edwards <bob@cs.anu.edu.au> writes:

> Or is it possible, over the same connection, to change the database
> user? My understanding of the frontend/backend protocol is that this
> is not allowed.

It is possible to change users.  

SET SESSION AUTHORIZATION <username>;

http://www.postgresql.org/docs/8.1/interactive/sql-set-session-authorization.html


Also just for completeness: http://www.securityfocus.com/bid/16650/info


-- 
Jorge Godoy      <jgodoy@gmail.com>