Re: [HACKERS] Re: New pg_pwd patch and stuff

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: psqlhack(at)maidast(dot)demon(dot)co(dot)uk (Peter T Mount)
Cc: hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Re: New pg_pwd patch and stuff
Date: 1998-01-13 02:10:08
Message-ID: 199801130210.VAA15274@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> On Mon, 12 Jan 1998, Bruce Momjian wrote:
> > Yes, I agree we should be able to restrict who gets into which
> > databases. It is on the TODO list.
> >
> > * More access control over who can create tables and access the database
> >
> > The reason it doesn't get complained about more is that many commercial
> > databases have similar lack of funciontality.
>
> Although not perfect, we can do this now by using different password files
> for each database, and having an entry for each database in pg_hba.conf

Someone sent in a patch to pg_hba.conf that allows use of the %
character to say people can only access databases with their name on it.
Marc will apply it soon, and Marc, we need a manual page mention for it.

--
Bruce Momjian
maillist(at)candle(dot)pha(dot)pa(dot)us

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc Howard Zuckman 1998-01-13 02:59:31 Re: [HACKERS] Alternate locations for databases
Previous Message Peter T Mount 1998-01-12 23:10:07 Re: [HACKERS] Re: New pg_pwd patch and stuff