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
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 |