SET ROLE versus SET SESSION AUTHORIZATION

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: colinthart(at)gmail(dot)com
Subject: SET ROLE versus SET SESSION AUTHORIZATION
Date: 2024-01-30 17:25:20
Message-ID: 170663552080.666.15305212584620999884@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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?

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2024-01-30 20:49:42 Re: CREATE ROLE inheritance details
Previous Message Bruce Momjian 2024-01-30 03:40:55 Re: CREATE ROLE inheritance details