| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Windsor | 2005-06-12 22:03:35 | Postgres 8.1 |
| Previous Message | Zlatko Matić | 2005-06-12 21:12:27 | retrieving information about password from MS Access front-end |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Volkan YAZICI | 2005-06-13 06:47:44 | Re: [INTERFACES] retrieving information about password from MS Access front-end |
| Previous Message | Zlatko Matić | 2005-06-12 21:12:27 | retrieving information about password from MS Access front-end |