Skip site navigation (1) Skip section navigation (2)

Re: retrieving information about password from MS

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>,pgsql-interfaces(at)postgresql(dot)org
Subject: Re: retrieving information about password from MS
Date: 2005-06-12 21:52:20
Message-ID: 1118613140.1183.1.camel@Andrea.peacock.de (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
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.




In response to

pgsql-interfaces by date

Next:From: Volkan YAZICIDate: 2005-06-13 06:47:44
Subject: Re: [INTERFACES] retrieving information about password from MS Access front-end
Previous:From: Zlatko MatićDate: 2005-06-12 21:12:27
Subject: retrieving information about password from MS Access front-end

pgsql-general by date

Next:From: Simon WindsorDate: 2005-06-12 22:03:35
Subject: Postgres 8.1
Previous:From: Zlatko MatićDate: 2005-06-12 21:12:27
Subject: retrieving information about password from MS Access front-end

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group