pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

SET 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>
  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-31 11:12  Laurenz Albe <laurenz.albe@cybertec.at>
  parent: PG Doc comments form <noreply@postgresql.org>
  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