From: Laurenz Albe <laurenz.albe@cybertec.at>
To: colinthart@gmail.com
To: pgsql-docs@lists.postgresql.org
Subject: Re: SET ROLE versus SET SESSION AUTHORIZATION
Date: Wed, 31 Jan 2024 12:12:03 +0100
Message-ID: <75a5f0f99356c263fedd8a02d3072e04d4073f84.camel@cybertec.at> (raw)
In-Reply-To: <170663552080.666.15305212584620999884@wrigleys.postgresql.org>
References: <170663552080.666.15305212584620999884@wrigleys.postgresql.org>
On Tue, 2024-01-30 at 17:25 +0000, PG Doc comments form wrote:
> Page: https://www.postgresql.org/docs/16/sql-set-role.html
> Description:
>
> "SET ROLE has effects comparable to SET SESSION AUTHORIZATION, but the
> privilege checks involved are quite different."
>
> What are the differences in privilege checks?
>
> How are the two commands the same and different, semantically?
The difference is revealed by "SELECT session_user".
I think that is pretty clearly described in the SET SESSION AUTHORIZATION
documentation page.
Yours,
Laurenz Albe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: laurenz.albe@cybertec.at, colinthart@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: SET ROLE versus SET SESSION AUTHORIZATION
In-Reply-To: <75a5f0f99356c263fedd8a02d3072e04d4073f84.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox