Re: [ADMIN] security

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [ADMIN] security
Дата
Msg-id Pine.LNX.4.21.0001162106110.1636-100000@localhost.localdomain
обсуждение исходный текст
Ответ на security  (sk.list@comset.net)
Список 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 по дате отправления:

Предыдущее
От: baumert@pilot-webdesign.de
Дата:
Сообщение: ...
Следующее
От: Richard NAGY
Дата:
Сообщение: Still having problems on compiling PostgreSQL 6.5.3 on IRIX 6.5