Hi, https://www.postgresql.org/docs/current/default-roles.html mentions the "Administrator" several times, but does not specify it further. I understand that it is mentioned elsewhere [1], but I think it would be beneficial to remind the reader on that page at least once that "Administrators" includes "roles with the CREATEROLE privilege" in the context of GRANTing and REVOKEing default privileges, e.g. with the attached patch.
Michael [1] e.g. at https://www.postgresql.org/docs/current/sql-createrole.html it is mentioned that CREATEROLE privs can be regarded as "almost-superuser-roles" -- Michael Banck Projektleiter / Senior Berater Tel.: +49 2166 9901-171 Fax: +49 2166 9901-100 Email: michael.ba...@credativ.de credativ GmbH, HRB Mönchengladbach 12080 USt-ID-Nummer: DE204566209 Trompeterallee 108, 41189 Mönchengladbach Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer Unser Umgang mit personenbezogenen Daten unterliegt folgenden Bestimmungen: https://www.credativ.de/datenschutz
diff --git a/doc/src/sgml/user-manag.sgml b/doc/src/sgml/user-manag.sgml index cc082521a2..cf1e3a948c 100644 --- a/doc/src/sgml/user-manag.sgml +++ b/doc/src/sgml/user-manag.sgml @@ -493,9 +493,10 @@ DROP ROLE doomed_role; <para> <productname>PostgreSQL</productname> provides a set of default roles which provide access to certain, commonly needed, privileged capabilities - and information. Administrators can GRANT these roles to users and/or - other roles in their environment, providing those users with access to - the specified capabilities and information. + and information. Administrators (including roles that have the + <literal>CREATEROLE</literal> privilege) can <command>GRANT</command> these + roles to users and/or other roles in their environment, providing those + users with access to the specified capabilities and information. </para> <para>