On Sun, 17 Feb 2002, Andreas Hierling wrote:
> I know, this should work with "ALTER USER...", But when I set the
> password this way, i�m still able to gain unrestricted access without a
> password. When setting a Password by creating the user, there�s no such
> problem. I�m 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.