Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC
Дата
Msg-id CAKAnmm+ODqpCAF+jbqWaGRD8UBJhS66Us0deWQ01+PbOiS4L8A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC
Список pgsql-general
On Thu, Sep 12, 2024 at 9:21 AM Andreas Joseph Krogh <andreas@visena.com> wrote:
Yes, it is theater, but that doesn't prevent “compliance people” to care about it. We have to take measures to prevent “information leaks”.

*shrug* Then the compliance people are not good at their jobs, frankly.

But if it works for you, go ahead. As Tom said, it will work 95% of the time. But it will break things that should work, and it will not prevent the ability to get the information in other ways. To be clear, we never recommend messing with the system catalogs, and this falls under the umbrella of messing with the system catalogs.

Cheers,
Greg

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