Re: docs: set role permission checking, do I read this wrong?
От | Daniel Westermann |
---|---|
Тема | Re: docs: set role permission checking, do I read this wrong? |
Дата | |
Msg-id | 985846a7-97e6-4c43-a34a-5541faf2c37c@dbi-services.com обсуждение исходный текст |
Ответ на | Re: docs: set role permission checking, do I read this wrong? ("David G. Johnston" <david.g.johnston@gmail.com>) |
Ответы |
Re: docs: set role permission checking, do I read this wrong?
|
Список | pgsql-docs |
On 10/18/23 09:26, David G. Johnston wrote:
Regards
Daniel
On Wednesday, October 18, 2023, Daniel Westermann <daniel.westermann@dbi-services.com> wrote:Thank you, this is what I see in the small example. Maybe it is my English, but this sentence sounds confusing.
"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.
Regards
Daniel
В списке pgsql-docs по дате отправления: