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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html