Re: de-encrypting a password

Поиск
Список
Период
Сортировка
От Andreas Wenk
Тема Re: de-encrypting a password
Дата
Msg-id 498D62CC.5030509@netzmeister-st-pauli.de
обсуждение исходный текст
Ответ на de-encrypting a password  (richard terry <rterry@pacific.net.au>)
Список pgsql-novice

richard terry schrieb:
> I wondered if it was possible to see what the original password put in was if
> one does a select * from pg_shadow where user = 'the_user'; and you end up
> with passwd as a great big long string.
>
> regards
>
> Ricahrd
>
Hi,

all passwords are stored as MD5 strings in PostgreSQL. MD5 is a one way
encryption. So as long as you do not use a paramater (-N) while creating
a new user, the password will be encrypted and you cannot see it in
plain text.

Cheers

Andy
--

St.Pauli - Hamburg - Germany

Andreas Wenk


В списке pgsql-novice по дате отправления:

Предыдущее
От: richard terry
Дата:
Сообщение: de-encrypting a password
Следующее
От: kulmacet101@kulmacet.com
Дата:
Сообщение: Creating a test database and table