alter user does not changes password

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-sql by date

  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