| From: | Lucas Brasilino <brasilino(at)recife(dot)pe(dot)gov(dot)br> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | alter user does not changes password |
| Date: | 2002-10-01 14:46:18 |
| Message-ID: | 3D99B53A.1020707@recife.pe.gov.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi all:
I know it's a silly question, but I've googling around and
searching mailist archive with no answer to my question:
I'm using self compiled PostgreSQL 7.2.1 in a RH 7.1 box.
As described in http://www.postgresql.org/idocs/index.php?sql-alteruser.html
I'm trying to change a user's password as:
alter user camara with password 'canabis!';
but when I try to connect:
$ psql -U camara dbcamara;
User "camara" logs with no password!!!! If I use -W option of psql
It prompts for password and I can enter whatever I want... it accepts!
It must be a feature.. not a bug... I know I'm making a mistake.. but..
where??
bests regards
--
[]'s
Lucas Brasilino
brasilino(at)recife(dot)pe(dot)gov(dot)br
http://www.recife.pe.gov.br
Emprel - Empresa Municipal de Informatica (pt_BR)
Municipal Computing Enterprise (en_US)
Recife - Pernambuco - Brasil
Fone: +55-81-34167078
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dima | 2002-10-01 14:49:57 | Re: alter user does not changes password |
| Previous Message | Michael Contzen | 2002-10-01 12:18:50 | How slow is distinct - 2nd |