doc: improve role option documentation

Bruce Momjian <bruce@momjian.us>

Commit: 21912e3c0262e2cfe64856e028799d6927862563
Author: Bruce Momjian <bruce@momjian.us>
Date: 2024-02-01T11:11:53Z
Releases: 17.0
doc:  improve role option documentation

Role option management was changed in Postgres 16.  This patch improves
the docs around these changes, including CREATE ROLE's INHERIT option,
inheritance handling, and grant's ability to change role options.

Discussion: https://postgr.es/m/Zab9GiV63EENDcWG@momjian.us

Co-authored-by: David G. Johnston

Backpatch-through: 16

Files

PathChange+/−
doc/src/sgml/ref/create_role.sgml modified +53 −34
doc/src/sgml/ref/grant.sgml modified +17 −12
doc/src/sgml/user-manag.sgml modified +4 −4

Documentation touched