From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Halley Pacheco de Oliveira <halleypo(at)yahoo(dot)com(dot)br> |
Cc: | pgsql-docs <pgsql-docs(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL 8.2.3 Documentation - createuser - echoed command |
Date: | 2007-02-26 17:34:17 |
Message-ID: | 200702261734.l1QHYHT00940@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
The -E/-N options control how the password is stored in the server, and
that is what you are seeing in different ENCRYPTED PASSWORD entries.
Generally, you should never use -N.
---------------------------------------------------------------------------
Halley Pacheco de Oliveira wrote:
> In the createuser command page is written:
>
> To create the user joe as a superuser, and assign a password immediately:
>
> $ createuser -P -s -e joe
> Enter password for new role: xyzzy
> Enter it again: xyzzy
> CREATE ROLE joe PASSWORD 'xyzzy' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
> CREATE ROLE
>
> In the above example, the new password isn't actually echoed when typed, but we show what was typed for clarity. However the password will appear in the echoed command, as illustrated ? so you don't want to use -e when assigning a password, if anyone else can see your screen.
>
> But it is not always the truth.
>
> When I use
>
> $ createuser -P -s -N -e joe
>
> I get:
>
> Enter password for new role: xyzzy
> Enter it again: xyzzy
> CREATE ROLE joe PASSWORD 'xyzzy' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
> CREATE ROLE
>
> (same as in the documentation)
>
> But when I use
>
> $ createuser -P -s -E -e joe
>
> (or don't use -N or -E) I get:
>
>
> CREATE ROLE joe ENCRYPTED PASSWORD 'md5b5f5ba1a423792b526f799ae4eb3d59e' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
>
> (the password is shown encrypted)
>
> The last two examples were executed using a "createuser (PostgreSQL) 8.2.0" local.
>
> But when I execute the createuser command from a remote machine using:
>
> # createuser --version
> createuser (PostgreSQL) 8.1.4
>
> # createuser -h Kubuntu -U sistemas -P -s -E -e joe
>
> I get:
>
> CREATE ROLE joe ENCRYPTED PASSWORD 'xyzzy' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
>
> (same as in the documentation, but different from the createuser 8.2.0 local)
>
> I would like to know the reason of the difference. Is it being caused by the different versions of createuser?
>
> The text is the same in the PostgreSQL 8.1.8 Documentation and in the PostgreSQL 8.2.3 Documentation, but it seems to me that the createuser behaviour is different in these versions.
>
> Thanks,
> Halley
>
>
>
>
>
> __________________________________________________
> Fale com seus amigos de gra?a com o novo Yahoo! Messenger
> http://br.messenger.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2007-03-02 05:32:11 | broken doc |
Previous Message | Halley Pacheco de Oliveira | 2007-02-25 10:23:37 | PostgreSQL 8.2.3 Documentation - createuser - echoed command |