Thread: No user restriction, Why?

No user restriction, Why?

From
"Ludwig Heusser"
Date:
Hallo dears PG-Users,

I have sucessfully installed the postgreSQL database an I want to administrate
the tables with phppgadmin. Almost ist perfekt except that I can't set a user
passwort. Wenn I add a new user by using the phppgadmin, the new user will be
created, but I allways can login without to give a password, Why?

Thanks for your precious help

Ludwig Heusser
Heusser Ludwig

-----------------------

Hch. Kündig & Cie. AG
Joweid Zentrum 11
8630 Rüti ZH
Switzerland

Phone: +41 (0)55 250 36 36
Direct line: +41 (0)55 250 36 43
Fax: +41 (0)55 250 36 01 or 02
E-Mail: wu@kundig-hch.ch

------------------------------------
You are welcome to visit us at: http://www.kundig-hch.ch/
------------------------------------





Re: No user restriction, Why?

From
Stephan Szabo
Date:
On Thu, 28 Aug 2003, Ludwig Heusser wrote:

> Hallo dears PG-Users,
>
> I have sucessfully installed the postgreSQL database an I want to administrate
> the tables with phppgadmin. Almost ist perfekt except that I can't set a user
> passwort. Wenn I add a new user by using the phppgadmin, the new user will be
> created, but I allways can login without to give a password, Why?

What does your pg_hba.conf say? If you've got lines using the "trust"
authentication mechanism, you may want to change those to one one the
others like "md5".