Message-ID: <45DB48C5.1000103@hagander.net>
Date: Tue, 20 Feb 2007 20:15:17 +0100
From: Magnus Hagander <magnus@hagander.net>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: Tony Caduto <tony_caduto@amsoftwaredesign.com>,
	pgsql-general@postgresql.org
Subject: Re: Password issue revisited
References: <45BCACDB.5050702@007Marketing.com>
	<200702201449.l1KEn0r21849@momjian.us>
	<20070220150507.GD11927@svr2.hagander.net>
	<45DB448A.3040308@amsoftwaredesign.com>
	<45DB4624.4060800@hagander.net> <18922.1171998826@sss.pgh.pa.us>
In-Reply-To: <18922.1171998826@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Tom Lane wrote:
> Magnus Hagander <magnus@hagander.net> writes:
>> Tony Caduto wrote:
>>> What about having a wallet type system where the user can create a pass
>>> phrase to protect a generated key that would get
>>> loaded once per session.  That is how KDE allows users to store passwords.
> 
>> If we wanted to do that, we could use the Windows API that's available
>> to do this. The idea with the pgpass flie is to have it compatible with
>> the unix version.
> 
> More to the point, that's far outside the scope of this project.  Use a
> PAM auth module that you like, or Kerberos or whatever.  I'm way past
> tired of "let's put yet another authentication technology in libpq" requests.

Just to make things clear, this wouldn't be about another auth method.
Windows has an API to store arbitrary passwords in a "secure way". At
least it does in XP+, not sure if it was in 2000.

Not saying it's a good idea, but it's not another auth tech for libpq.

//Magnus