Re: docs: set role permission checking, do I read this wrong?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: docs: set role permission checking, do I read this wrong?
Дата
Msg-id CAKFQuwY9pa475guw29sppEM3FqcmPRXFeLqCAx1dX2vrzsg7Fg@mail.gmail.com
обсуждение исходный текст
Ответ на docs: set role permission checking, do I read this wrong?  (Daniel Westermann <daniel.westermann@dbi-services.com>)
Ответы Re: docs: set role permission checking, do I read this wrong?  (Daniel Westermann <daniel.westermann@dbi-services.com>)
Список pgsql-docs
Дерево обсуждения
On Wednesday, October 18, 2023, Daniel Westermann <daniel.westermann@dbi-services.com> wrote:

"After |SET ROLE|, permissions checking for SQL commands is carried out as though the named role were the one that had logged in originally."

Isn't it the other way around and permission checking is done as "a", or do I read this wrong?

It is saying “a” is the current_user:

When you set role to (named role) a the system behaves as if (named role) a had logged in originally (even though, in that example, postgres is the role that originally logged in)

David J.

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

Предыдущее
От: Daniel Westermann
Дата:
Сообщение: docs: set role permission checking, do I read this wrong?
Следующее
От: Daniel Westermann
Дата:
Сообщение: Re: docs: set role permission checking, do I read this wrong?