password encryption

Поиск
Список
Период
Сортировка
Искать

password encryption

От:
"Silesky Marketing Inc, Support" <support@silesky.com>
Дата:
Hello,

I want to encrypt passwords with Postgresql the way mySQL does it with :

UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';

How can I do that ?

Thanks a lot,

Laurent


Re: [SQL] password encryption

От:
"Roderick A. Anderson" <raanders@altoplanos.net>
Дата:
On Fri, 21 Jul 2000, Silesky Marketing Inc, Support wrote:

> Hello,
> 
> I want to encrypt passwords with Postgresql the way mySQL does it with :
> 
> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';

Check out the ALTER command.

ALTER USER username
    [ WITH PASSWORD 'password' ]
    [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
    [ VALID UNTIL 'abstime' ]


Rod
--
Roderick A. Anderson
raanders@altoplanos.net               Altoplanos Information Systems, Inc.
Voice: 208.765.6149                            212 S. 11th Street, Suite 5
FAX: 208.664.5299                                  Coeur d'Alene, ID 83814

FAQ