Re: permission denied (even when run as postgres) for views aftermaking their owner nosuperuser

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: permission denied (even when run as postgres) for views aftermaking their owner nosuperuser
Дата
Msg-id CAKFQuwa9AVro05Qv_du+Nu23Z17nLLhhSYtY9H7pBfLgNm0AHg@mail.gmail.com
обсуждение исходный текст
Ответ на permission denied (even when run as postgres) for views after makingtheir owner nosuperuser  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Ответы Re: permission denied (even when run as postgres) for views aftermaking their owner nosuperuser
Список pgsql-admin
Дерево обсуждения
On Fri, Jan 26, 2018 at 7:32 AM, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
In fact, there is no way on earth I can regain access to view fuser.testforfu for any user (postgres included) unless I change its ownership (or make fuser a superuser).

is this normal? documented? Am I missing anything?

​When dealing with views the owner of the view is performing all of the queries.  So if you make the view owner lack permission to access the underlying tables the view isn't going to work no matter the permissions of the view caller.

Documented here:

https://www.postgresql.org/docs/10/static/sql-createview.html

"Access to tables referenced in the view is determined by permissions of the view owner."

David J.


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

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: permission denied (even when run as postgres) for views after makingtheir owner nosuperuser
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: permission denied (even when run as postgres) for views aftermaking their owner nosuperuser