More obvious clarification is needed about how RLS interacts with views

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема More obvious clarification is needed about how RLS interacts with views
Дата
Msg-id 156045557781.1350.3998342005368853619@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/sql-createpolicy.html
Description:

It's not clear enough from reading the documentation on RLS security policy
that schema designers need to pay special attention to views and their
ownership.  (Views will bypass RLS security in the common case that they are
owned by a super user.)  I have seen this misunderstanding lead to
unexpected data exposure.

This *is* clarified at the very bottom of the Notes section on the `create
policy` document, but I believe it justifies having a clear and prominent
call out.  Thank you!

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

Предыдущее
От: Pavel Luzanov
Дата:
Сообщение: ATTACH/DETACH partitions and locking
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: ATTACH/DETACH partitions and locking