X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id B77C6528BB;
	Sun, 12 Jun 2005 18:52:37 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 99140-02; Sun, 12 Jun 2005 21:52:27 +0000 (GMT)
Received: from service-web.de (p15093784.pureserver.info [217.160.106.224])
	by svr1.postgresql.org (Postfix) with ESMTP id 46992528B2;
	Sun, 12 Jun 2005 18:52:26 -0300 (ADT)
Received: from [192.168.2.99] (G6582.g.pppool.de [80.185.101.130])
	by service-web.de (Postfix) with ESMTP id 6E23D20003A;
	Sun, 12 Jun 2005 23:52:26 +0200 (CEST)
Subject: Re: retrieving information about password  from MS
From: Tino Wildenhain <tino@wildenhain.de>
To: Zlatko =?iso-8859-2?Q?Mati=E6?= <zlatko.matic1@sb.t-com.hr>
Cc: Postgresql-General <pgsql-general@postgresql.org>,
	pgsql-interfaces@postgresql.org
In-Reply-To: <00b901c56f93$b6d20520$8c261dc3@zlatkovyfkpgz6>
References: <00b901c56f93$b6d20520$8c261dc3@zlatkovyfkpgz6>
Content-Type: text/plain; charset=iso-8859-2
Date: Sun, 12 Jun 2005 23:52:20 +0200
Message-Id: <1118613140.1183.1.camel@Andrea.peacock.de>
Mime-Version: 1.0
X-Mailer: Evolution 2.0.4 
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.06 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200506/608
X-Sequence-Number: 79316

Am Sonntag, den 12.06.2005, 23:12 +0200 schrieb Zlatko Matiæ:
> How could I retrieve information about actual user password, if md5
> method is set in pg_hba.conf ? 
> I want to create VBA procedure that compares value in text box with
> actual password to determine if it is the same. As the password is
> encrypted (md5) I can't read it from pg_shaddow system table. How to
> retrieve decrypted value from pg_shaddow? Or at least, how to transfer
> value from text-box (MS Access) to Postgres so that Postgres can
> determine whether those two values are the same ?

You cant. md5 really is a hash, not encryption (there is no decryption)
You would just try to connect - postgres will tell you if the password
is wrong.