Re: [ADMIN] security

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