doc: Clarify requirements for SET ROLE.

Nathan Bossart <nathan@postgresql.org>

Commit: 3330a8d1b792375ae3f7dffb7eb0a45c907cbc72
Author: Nathan Bossart <nathan@postgresql.org>
Date: 2024-03-24T20:23:55Z
Releases: 17.0
doc: Clarify requirements for SET ROLE.

Since commit 3d14e171e9, SET ROLE has required the current session
user to have membership with the SET option in the target role, but
the SET ROLE documentation only mentions the membership
requirement.  This commit adds this important detail to the SET
ROLE page.

Reviewed-by: Robert Haas
Discussion: https://postgr.es/m/CA%2BRLCQysHtME0znk2KUMJN343ksboSRQSU-hCnOjesX6VK300Q%40mail.gmail.com
Backpatch-through: 16

Files

PathChange+/−
doc/src/sgml/ref/set_role.sgml modified +4 −2

Documentation touched

Discussion