Re: [INTERFACES] retrieving information about password from MS Access front-end
От | Zlatko Matić |
---|---|
Тема | Re: [INTERFACES] retrieving information about password from MS Access front-end |
Дата | |
Msg-id | 000001c57067$f6a22110$45221dc3@zlatkovyfkpgz6 обсуждение исходный текст |
Ответ на | retrieving information about password from MS Access front-end (Zlatko Matić <zlatko.matic1@sb.t-com.hr>) |
Список | pgsql-general |
Thanks. ----- Original Message ----- From: "Volkan YAZICI" <volkan.yazici@gmail.com> To: "Zlatko Matić" <zlatko.matic1@sb.t-com.hr> Cc: <pgsql-general@postgresql.org>; <pgsql-interfaces@postgresql.org> Sent: Monday, June 13, 2005 8:47 AM Subject: Re: [GENERAL] [INTERFACES] retrieving information about password from MS Access front-end > Hi, > > On 6/13/05, Zlatko Matić <zlatko.matic1@sb.t-com.hr> wrote: >> 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? > > It's (practically) impossible to decrypt a MD5 hashed password. > >> 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 need to MD5 hash the input passsword and compare hashed input > password with the one in pg_shadow. For instance: > > -- $1 for password input. > SELECT usernm FROM recs WHERE passwd = md5($1) > > Furthermore, it'll bring some potential security problems to be able > to access pg_shadow which requires db admin permissions. > > Regards. > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
В списке pgsql-general по дате отправления: