| From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | Vicente Vives <vicent(at)aimplas(dot)es> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: usernames and passwords |
| Date: | 2002-07-22 11:05:28 |
| Message-ID: | 1027335929.16952.51.camel@linda |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)Elphick(at)lfix(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Artur Pietruk | 2002-07-22 11:08:44 | Re: usernames and passwords |
| Previous Message | Roger Mathis | 2002-07-22 10:50:37 | Object oriented functions in PostgreSQL |