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

2023-10-18 Thread David G. Johnston
On Wednesday, October 18, 2023, Daniel Westermann < daniel.westerm...@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. > How would you document that behavior? The sentence is correct; that doesn’t mean it

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

2023-10-18 Thread Daniel Westermann
On 10/18/23 09:26, David G. Johnston wrote: On Wednesday, October 18, 2023, Daniel Westermann 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

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

2023-10-18 Thread David G. Johnston
On Wednesday, October 18, 2023, Daniel Westermann < daniel.westerm...@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 checki

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

2023-10-18 Thread Daniel Westermann
Hi, when reading the documentation about "set role" there is this: https://www.postgresql.org/docs/16/sql-set-role.html "After |SET ROLE|, permissions checking for SQL commands is carried out as though the named role were the one that had logged in originally." Given this: postgres=# select