Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1BE224762C0 for ; Tue, 1 Oct 2002 10:47:07 -0400 (EDT) Received: from pcr.recife.pe.gov.br (unknown [200.249.133.130]) by postgresql.org (Postfix) with ESMTP id 4C3B04758BD for ; Tue, 1 Oct 2002 10:47:03 -0400 (EDT) Received: from pcr.recife.pe.gov.br (localhost [127.0.0.1]) by pcr.recife.pe.gov.br (8.11.2/8.11.2) with ESMTP id g91EmvM03456 for ; Tue, 1 Oct 2002 11:48:57 -0300 Received: from recife.pe.gov.br (proxy.recife.pe.gov.br [200.249.133.135]) by pcr.recife.pe.gov.br (8.11.2/8.11.2) with ESMTP id g91EmuZ03450 for ; Tue, 1 Oct 2002 11:48:56 -0300 Message-ID: <3D99B53A.1020707@recife.pe.gov.br> Date: Tue, 01 Oct 2002 11:46:18 -0300 From: Lucas Brasilino Organization: Emprel - Empresa Municipal de Informatica User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.4) Gecko/20011126 Netscape6/6.2.1 X-Accept-Language: en-us MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: alter user does not changes password Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/2 X-Sequence-Number: 9720 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@recife.pe.gov.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