pg_stats entries visibility with RLS enabled

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема pg_stats entries visibility with RLS enabled
Дата
Msg-id 170205394886.398198.4628897348940629963@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/view-pg-stats.html
Description:

First paragraph for the pg_stats view says: "This view allows access only to
rows of pg_statistic that correspond to tables the user has permission to
read, and therefore it is safe to allow public read access to this view."

I think it would be worth to mention that with RLS enabled for the table the
rows will also be hidden to not reveal values from the rows not visible to
the user.

    Wojtek

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Where is using a table name as a "row value" documented?
Следующее
От: PG Doc comments form
Дата:
Сообщение: unclear wording re: spoofing prevention on network connections