Thread: Passwords

Passwords

From

"Fontenot, Paul"

Date:

28 March 2003, 17:08:57

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)

Re: Passwords

From

Larry Rosenman

Date:

28 March 2003, 17:15:35

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

Re: Passwords

From

Bruce Momjian

Date:

28 March 2003, 18:28:58

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