pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedSET ROLE versus SET SESSION AUTHORIZATION
2+ messages / 2 participants
[nested] [flat]
* SET ROLE versus SET SESSION AUTHORIZATION
@ 2024-01-30 17:25 PG Doc comments form <noreply@postgresql.org>
2024-01-31 11:12 ` Re: SET ROLE versus SET SESSION AUTHORIZATION Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2024-01-30 17:25 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: colinthart@gmail.com
The following documentation comment has been logged on the website:
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?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: SET ROLE versus SET SESSION AUTHORIZATION
2024-01-30 17:25 SET ROLE versus SET SESSION AUTHORIZATION PG Doc comments form <noreply@postgresql.org>
@ 2024-01-31 11:12 ` Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2024-01-31 11:12 UTC (permalink / raw)
To: colinthart@gmail.com; pgsql-docs@lists.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-01-31 11:12 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-01-30 17:25 SET ROLE versus SET SESSION AUTHORIZATION PG Doc comments form <noreply@postgresql.org>
2024-01-31 11:12 ` Laurenz Albe <laurenz.albe@cybertec.at>
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