From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
Cc: | o15611(at)gmail(dot)com |
Subject: | wrong statement in the https://www.postgresql.org/docs/current/predefined-roles.html |
Date: | 2025-06-12 08:19:17 |
Message-ID: | 174971635747.926316.16174387375000947009@wrigleys.postgresql.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2025-06-12 13:15:43 | Re: wrong statement in the https://www.postgresql.org/docs/current/predefined-roles.html |
Previous Message | Robert Treat | 2025-06-11 15:54:51 | Re: Add missing references to database object statistics manipulation functions in documentation |