On Mon, 2002-07-22 at 11:16, Vicente Vives wrote:
>
> Hi .
> I have a server running PostgreSQL Version 6.5, and i have a problem.
> I grant some distinct privileges to some users (and that works). The
> problem
> is that those users can log in with any password. Each user has a
> password
> assigned but not matter the password the user use to log in, if the user
> exists always will get access to the database.
Look at $PGDATA/pg_hba.conf
This self-documenting file contains the access parameters.
Incidentally, version 6.5 is very old and buggy. You should consider
upgrading to the current version, 7.2.1
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Then Peter and the other apostles answered and said,
We ought to obey God rather than men."
Acts 5:29