Postgres Pro
Downloads
Home   >   mailing lists

Re: docs: set role permission checking, do I read this wrong? - Mailing list pgsql-docs

From David G. Johnston
Subject Re: docs: set role permission checking, do I read this wrong?
Date
Msg-id CAKFQuwY9pa475guw29sppEM3FqcmPRXFeLqCAx1dX2vrzsg7Fg@mail.gmail.com
Whole thread Raw
In response to docs: set role permission checking, do I read this wrong?  (Daniel Westermann <daniel.westermann@dbi-services.com>)
Responses Re: docs: set role permission checking, do I read this wrong?
List pgsql-docs
Tree view
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 by date:

Previous
From: Daniel Westermann
Date:
Subject: docs: set role permission checking, do I read this wrong?
Next
From: Daniel Westermann
Date:
Subject: Re: docs: set role permission checking, do I read this wrong?