Re: Allow pg_read_all_stats to read pg_stat_progress_*

Поиск
Список
Период
Сортировка
От Andrey M. Borodin
Тема Re: Allow pg_read_all_stats to read pg_stat_progress_*
Дата
Msg-id AED5F9D1-6EE7-4559-B261-39F1AD6D1695@yandex-team.ru
обсуждение исходный текст
Ответ на Re: Allow pg_read_all_stats to read pg_stat_progress_*  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: Allow pg_read_all_stats to read pg_stat_progress_*
Список pgsql-hackers

> 16 апр. 2020 г., в 17:46, Magnus Hagander <magnus@hagander.net> написал(а):
>
>
> If we do that, it may be better that we define "PGSTAT_VIEW_PRIV()" or
> something like and replace the all occurances of the idiomatic
> condition with it.
>
> You mean something like the attached?
>
> <allow_read_all_stats3.diff>

Is it correct that we use DEFAULT_ROLE_READ_ALL_STATS regardless of inheritance? I'm not familiar with what is
inheritedand what is not, so I think it's better to ask explicitly. 

+#define HAS_PGSTAT_PERMISSIONS(role)     (is_member_of_role(GetUserId(), DEFAULT_ROLE_READ_ALL_STATS) ||
has_privs_of_role(GetUserId(),role)) 

Besides this, the patch looks good to me.
Thanks!

Best regards, Andrey Borodin,


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

Предыдущее
От: Victor Yegorov
Дата:
Сообщение: Re: Poll: are people okay with function/operator table redesign?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Allow pg_read_all_stats to read pg_stat_progress_*