From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | sk(dot)list(at)comset(dot)net |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: [ADMIN] security |
Date: | 2000-01-16 20:13:08 |
Message-ID: | Pine.LNX.4.21.0001162106110.1636-100000@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 2000-01-15, sk(dot)list(at)comset(dot)net mentioned:
> I need to prevent user access to other user's database.
> By default any user can connect to any database and read its scheme at least.
> How to restrict this access?
> User should connect to database he have access only.
If you are using ident "authentication" then you can do that by setting up
a different mapping file for each database. See pg_hba.conf for
details. If you're using password authentication you have to set up a
different password file for each database. See again pg_hba.conf.
--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
From | Date | Subject | |
---|---|---|---|
Next Message | baumert | 2000-01-16 22:53:59 | |
Previous Message | Andre Schroeter | 2000-01-16 15:29:04 | subscribe |