Re: Problem with pg_user (somewhat urgent)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with pg_user (somewhat urgent)
Дата
Msg-id 4266.1066093012@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problem with pg_user (somewhat urgent)  (Oliver Fromme <olli@lurza.secnetix.de>)
Список pgsql-novice
Oliver Fromme <olli@lurza.secnetix.de> writes:
> We have a PostgreSQL 7.3.4 cluster which is used by several
> customers.  Every customer has his own database.  I have
> revoked SELECT access on pg_user from the customers, because
> they should not be able to see which other customers exist
> on the cluster.

That is a bad idea (and incomplete anyway; wouldn't looking at
pg_database give the same information?)

If you really need that much separation, give each customer his own
database cluster (postmaster).

            regards, tom lane

В списке pgsql-novice по дате отправления:

Предыдущее
От: Systems Administrator
Дата:
Сообщение: SQL from PLPerl
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: SQL from PLPerl