Re: [general] Permissions

From: Travis Bauer <trbauer(at)indiana(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [general] Permissions
Date: 2001-11-12 23:16:54
Message-ID: 200111122316.fACNGt608214@whale.cs.indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you. This worked. In testing it out, I noticed that postgres only
considers the first eight charaters of the password. So

abcdefghijklm
abcdefghmlkji

are considered the same by postgres. Is that correct?

Travis

On Monday 12 November 2001 01:01, Jeff Davis enlightened me by saying:
> PostgreSQL has, it seems, a somewhat weak permissions system, although it
> definately gets the job done.
>
> What you can do is have a seperate pg_hba.conf entry for every
> user/database combination you would like to be able to connect. To make
> this work, make a seperate password file for each user using pg_passwd.
> Lets say you call two files a_passwd and b_passwd (in accordance with your
> example), then make the lines:
>
. . .

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2001-11-12 23:17:32 Re: 7.0.2 -> 7.1 performance drop
Previous Message Frank Bax 2001-11-12 22:53:13 Re: 7.0.2 -> 7.1 performance drop