Re: Allow pg_read_all_stats to read pg_stat_progress_*

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Allow pg_read_all_stats to read pg_stat_progress_*
Дата
Msg-id 11247.1587391931@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Allow pg_read_all_stats to read pg_stat_progress_*  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: Allow pg_read_all_stats to read pg_stat_progress_*
Список pgsql-hackers
Stephen Frost <sfrost@snowman.net> writes:
> Ugh.  That doesn't make it correct though..  We really should be using
> has_privs_of_role() for these cases (and that goes for all of the
> default role cases- some of which are correct and others are not, it
> seems).

I have a different concern about this patch: while reading statistical
values is fine, do we REALLY want pg_read_all_stats to enable
pg_stat_get_activity(), ie viewing other sessions' command strings?
That opens security considerations that don't seem to me to be covered
by the description of the role.

            regards, tom lane



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

Предыдущее
От: Antonin Houska
Дата:
Сообщение: Re: More efficient RI checks - take 2
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Allow pg_read_all_stats to read pg_stat_progress_*