[DOCS] Row Level Security Policies documentation doesn't mention lack ofsupport for views

Поиск
Список
Период
Сортировка
От deinspanjer@gmail.com
Тема [DOCS] Row Level Security Policies documentation doesn't mention lack ofsupport for views
Дата
Msg-id 20170629142511.1481.84436@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [DOCS] Row Level Security Policies documentation doesn't mentionlack of support for views
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/ddl-rowsecurity.html
Description:

The policy documentation page is great, and the example in it is very
informative, but I just discovered a major flaw in our implementation of it
that I would like to see mentioned in the documentation.

If you create a view on a table, any queries against the view are in the
context of the view creator rather than the actual current user.

So, in the example on the page, if the admin creates a view of the passwd
table and grants access to this view, alice would no longer be subject to
any of the RLS policies as long as she used the view instead of the real
table.

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

Предыдущее
От: mudit0201@gmail.com
Дата:
Сообщение: [DOCS] Password encryption
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [DOCS] Password encryption