Re: Opinion wanted: Default select rights for users via public schema

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Opinion wanted: Default select rights for users via public schema
Дата
Msg-id 16039.1072106469@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Opinion wanted: Default select rights for users via public schema  (Oli Sennhauser <oli.sennhauser@bluewin.ch>)
Ответы Re: Opinion wanted: Default select rights for users via public
Список pgsql-admin
Oli Sennhauser <oli.sennhauser@bluewin.ch> writes:
> I found that all users have access to pg_class etc. by default. In my
> opinion this causes some security questions or at least can make users
> curious about things they should not.

This isn't going to change, because it would break too many clients
(as indeed you just found out).  Give users their own databases if you
feel you need that much separation.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: CREATE USER system privilege?
Следующее
От: Sai Hertz And Control Systems
Дата:
Сообщение: Unix 2038 And PostgreSQL