Re: [ADMIN] User based access - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: [ADMIN] User based access
Date
Msg-id 199812070307.WAA19741@candle.pha.pa.us
Whole thread Raw
In response to User based access  (Paul Dwerryhouse <paul@xenu.ee.mu.oz.au>)
List pgsql-admin
>
> Hi all,
>
> Would I be correct in saying that there is no way to allow a few users to
> have access to a database, but deny others, under Postgresql?
>
> I have scoured the documentation (which draws a blank) and have looked
> through other similar questions to this mailing list (which all seem to
> have gone unanswered).
>
> I'm not having any problems creating users, or using the pg_hba.conf -
> all I want to do is prevent some postgres users from accessing certain
> databases...

hba_conf has that ability.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-admin by date:

Previous
From: Paul Dwerryhouse
Date:
Subject: User based access
Next
From: Loris.Renggli@sphys.unil.ch (Renggli Loris)
Date:
Subject: HELP: postgres on Digital Unix