Re: wrong statement in the https://www.postgresql.org/docs/current/predefined-roles.html

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: o15611(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: wrong statement in the https://www.postgresql.org/docs/current/predefined-roles.html
Date: 2025-06-12 13:15:43
Message-ID: 7ac651fd911cbf737fd78062658d5b5868031080.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Thu, 2025-06-12 at 08:19 +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/14/predefined-roles.html
> Description:
>
> Page: https://www.postgresql.org/docs/current/predefined-roles.html
> Wrong statement: "Administrators (including roles that have the CREATEROLE
> privilege) can GRANT these roles to users and/or other roles in their
> environment, providing those users with access to the specified capabilities
> and information."
> Suggested statement: "SUPERUSER or roles granted with the ADMIN option on
> the particular predifined roles can GRANT these roles other roles, providing
> those users with access to the specified capabilities and information."
> Testcase:
> postgres=> create role bob;
> CREATE ROLE
> postgres=> grant pg_checkpoint to bob;
> ERROR: permission denied to grant role "pg_checkpoint"
> DETAIL: Only roles with the ADMIN option on role "pg_checkpoint" may grant
> this role.
> postgres=> grant pg_create_subscription to bob;
> ERROR: permission denied to grant role "pg_create_subscription"
> DETAIL: Only roles with the ADMIN option on role "pg_create_subscription"
> may grant this role.

+1

That looks like a clear oversight.

Yours,
Laurenz Albe

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Fujii Masao 2025-06-13 02:28:28 Re: Clarify VACUUM FULL exclusion in total_vacuum_time docs
Previous Message PG Doc comments form 2025-06-12 08:19:17 wrong statement in the https://www.postgresql.org/docs/current/predefined-roles.html