Обсуждение: security

Поиск
Список
Период
Сортировка

security

От
sk.list@comset.net
Дата:
Hi!

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.

SKiller
--------------------------
Sergei Keler
WebMaster of "ComSet"
E-Mail: skiller@comset.net
http://www.comset.net
--------------------------

Re: [ADMIN] security

От
Peter Eisentraut
Дата:
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