Re: usernames and passwords - Mailing list pgsql-admin

From Oliver Elphick
Subject Re: usernames and passwords
Date
Msg-id 1027335929.16952.51.camel@linda
Whole thread Raw
In response to usernames and passwords  (Vicente Vives <vicent@aimplas.es>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "Roger Mathis"
Date:
Subject: Object oriented functions in PostgreSQL
Next
From: Artur Pietruk
Date:
Subject: Re: usernames and passwords