Re: pgsql: Fix search_path to a safe value during maintenance operations.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: pgsql: Fix search_path to a safe value during maintenance operations.
Дата
Msg-id CAKFQuwZApdEVfBSg7O9AbP+=gyWsvkqHkYNOBBw8+GpV4An4yg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgsql: Fix search_path to a safe value during maintenance operations.  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-committers
Дерево обсуждения
On Tue, Jun 13, 2023 at 1:55 PM Jeff Davis <pgsql@j-davis.com> wrote:
Perhaps the objections in that thread were because the proposal
involved inferring the privilege to ANALYZE from other privileges,
rather than having an explicit MAINTAIN privilege?


That is true; but it seems worth being explicit whether we expect the user to only be able to run "ANALYZE" using defaults (like auto-analyze would do) or if this additional capability is assumed to be part of the grant.  I do imagine you'd want to be able to set the statistic target in order to do vacuum --analyze-in-stages with a non-superuser.

David J.

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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: pgsql: Fix search_path to a safe value during maintenance operations.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pgsql: Fix search_path to a safe value during maintenance operations.