From: Tino Wildenhain <tino@wildenhain.de>
To: Zlatko Matić <zlatko.matic1@sb.t-com.hr>
Cc: Postgresql-General <pgsql-general@postgresql.org>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: retrieving information about password from MS
Date: Sun, 12 Jun 2005 23:52:20 +0200
Message-ID: <1118613140.1183.1.camel@Andrea.peacock.de> (raw)
In-Reply-To: <00b901c56f93$b6d20520$8c261dc3@zlatkovyfkpgz6>
References: <00b901c56f93$b6d20520$8c261dc3@zlatkovyfkpgz6>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tino@wildenhain.de, zlatko.matic1@sb.t-com.hr, pgsql-general@postgresql.org
Subject: Re: retrieving information about password from MS
In-Reply-To: <1118613140.1183.1.camel@Andrea.peacock.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox