Re: Changing Passwords as Encrypted not Clear-Text

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: Changing Passwords as Encrypted not Clear-Text
Дата
Msg-id CABUevEw5+DoBq1=W6+Q_Sp-xbRNtju8EhZVNwYYVTZ=CquXjzg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Changing Passwords as Encrypted not Clear-Text  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-general
Дерево обсуждения 
On Mon, Dec 19, 2011 at 15:31, Guillaume Lelarge <guillaume@lelarge.info> wrote:
> On Mon, 2011-12-19 at 15:01 +0200, MURAT KOÇ wrote:
>> Is it possible to see changing passwords as encrypted?
>
> Nope.
>
>>  How should I change password or what is the correct sql statement to change user password?
>>
>
> There's only one way to change a password: ALTER USER... PASSWORD...

Not really. You can use "\password" in psql, or you can use
PQencryptPassword() in libpq. I don't know if that function is exposed
in other client drivers, but it's certainly been in libpq for quite a
while.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Feature Request: Better handling of foreign keys in DELETE statements
Следующее
От: Patrick Kevin McCaffrey
Дата:
Сообщение: Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."