Re: [ADMIN] security - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: [ADMIN] security
Date
Msg-id Pine.LNX.4.21.0001162106110.1636-100000@localhost.localdomain
Whole thread Raw
In response to security  (sk.list@comset.net)
List pgsql-admin
On 2000-01-15, sk.list@comset.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@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



pgsql-admin by date:

Previous
From: baumert@pilot-webdesign.de
Date:
Subject: ...
Next
From: Richard NAGY
Date:
Subject: Still having problems on compiling PostgreSQL 6.5.3 on IRIX 6.5