doc: Clarify requirements for SET ROLE.
authorNathan Bossart <nathan@postgresql.org>
Sun, 24 Mar 2024 20:23:55 +0000 (15:23 -0500)
committerNathan Bossart <nathan@postgresql.org>
Sun, 24 Mar 2024 20:23:55 +0000 (15:23 -0500)
commit3330a8d1b792375ae3f7dffb7eb0a45c907cbc72
tree9bbeca133d5c9a923e8055c41e964964bf0831e6
parentaf1d3958432c9438c4ec168bd16bdf9a91066a9f
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
doc/src/sgml/ref/set_role.sgml