pg_shadow and pgcrypto

Поиск
Список
Период
Сортировка
От Frank Cavaliero
Тема pg_shadow and pgcrypto
Дата
Msg-id OF4FB30822.73058640-ON85257ACA.00729BE9-85257ACA.0072A999@us.ibm.com
обсуждение исходный текст
Список pgsql-general
Hi all,

I'm currently performing a hash check for password verification.    I'm generating an md5  hash or checking for plain text in pg_shadow.  However, outside of these two "out-of-the-box" options, what if someone is using pg-crypto or any other PAM ?  How can I differentiate between say md5 and pgcrypto ?  I see the md5 is prefixed in hash in pg_shadow.  I was wondering what other prefixes may exist, say for pgcrypto.  If you have an examples of what a pgcrypto or any other PAM hash would look like (or what they would at least begin with), that would be great.

Thanks,
Frank





Frank Cavaliero

Database Administrator

IBM Infosphere Guardium

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

Предыдущее
От: Sergey Konoplev
Дата:
Сообщение: Re: Which is faster: char(14) or varchar(14)
Следующее
От: Edson Richter
Дата:
Сообщение: Re: Which is faster: char(14) or varchar(14)