Обсуждение: Passwords
I've recently moved from MySQL to PostgreSQL when I installed RH 8.0 and I have managed to get everything the way I want EXCEPT for one, how do I set a users password? The createuser man page is not that clear to me on this one. I'm using PostgreSQL Version 7.2.2-1 (shipped with RH 8.0)
ler=# \h alter user Command: ALTER USER Description: change a database user account Syntax: ALTER USER username [ [ WITH ] option [ ... ] ] where option can be: [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | CREATEDB | NOCREATEDB | CREATEUSER | NOCREATEUSER | VALID UNTIL 'abstime' ALTER USER username SET variable { TO | = } { value | DEFAULT } ALTER USER username RESET variable ler=# --On Friday, March 28, 2003 12:08:51 -0700 "Fontenot, Paul" <Paul.Fontenot@bannerhealth.com> wrote: > I've recently moved from MySQL to PostgreSQL when I installed RH 8.0 and > I have managed to get everything the way I want EXCEPT for one, how do I > set a users password? The createuser man page is not that clear to me on > this one. > > I'm using PostgreSQL Version 7.2.2-1 (shipped with RH 8.0) > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
The man page looks pretty clear to me: -P --pwprompt If given, createuser will issue a prompt for the password of the new user. This is not necessary if you do not plan on using password authentication. --------------------------------------------------------------------------- Fontenot, Paul wrote: > I've recently moved from MySQL to PostgreSQL when I installed RH 8.0 and > I have managed to get everything the way I want EXCEPT for one, how do I > set a users password? The createuser man page is not that clear to me on > this one. > > I'm using PostgreSQL Version 7.2.2-1 (shipped with RH 8.0) > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073