Re: Set Passsword for existing User

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Andreas Hierling <A(dot)Hierling(at)netcafe-konstanz(dot)de>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Set Passsword for existing User
Date: 2002-02-21 22:59:24
Message-ID: 20020221145735.J23226-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Sun, 17 Feb 2002, Andreas Hierling wrote:

> I know, this should work with "ALTER USER...", But when I set the
> password this way, im still able to gain unrestricted access without a
> password. When setting a Password by creating the user, theres no such
> problem. Im working with PostgreSQL 7.1 on a SuSE 7.1 Linux. Hope
> anyone knows this Problem or is able to tell me what i have done wrong.

Are you sure that you've set up pg_hba.conf correctly? In most cases not
being prompted for a password is due to a trust entry there.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2002-02-21 23:01:52 Re: Problem/Question
Previous Message Bruce Momjian 2002-02-21 21:52:37 Re: FATAL 1: configuration file 'postgresql.conf' has wrong