Re: ALTER ROLE documentation improvement

From: vignesh C <vignesh21(at)gmail(dot)com>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: Yurii Rashkovskii <yrashk(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: ALTER ROLE documentation improvement
Date: 2024-01-14 10:47:41
Message-ID: CALDaNm1ASWOxqA7-boZLm2TAXM5frp0RmCM2-FGxJHoXGVvO0g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 26 Sept 2023 at 04:38, Nathan Bossart <nathandbossart(at)gmail(dot)com> wrote:
>
> On Fri, Sep 15, 2023 at 02:25:38PM -0700, Yurii Rashkovskii wrote:
> > Thank you for the feedback. I've updated the glossary and updated the
> > terminology to be consistent. Please see the new patch attached.
>
> Thanks for the new version of the patch.
>
> This user owns all system catalog tables in each database. It is also the role
> from which all granted permissions originate. Because of these things, this
> - role may not be dropped.
> + role may not be dropped. This role must always be a superuser, it can't be changed
> + to be a non-superuser.
>
> I think we should move this note to the sentence just below that mentions
> its superuserness. Maybe it could look something like this:
>
> This role also behaves as a normal database superuser, and its
> superuser status cannot be revoked.

Modified

> + Database superusers can change any of these settings for any role, except for
> + changing <literal>SUPERUSER</literal> to <literal>NOSUPERUSER</literal>
> + for a <glossterm linkend="glossary-bootstrap-superuser">bootstrap superuser</glossterm>.
>
> nitpick: s/a bootstrap superuser/the bootstrap superuser

Modified

> #: commands/user.c:871
> #, c-format
> -msgid "The bootstrap user must have the %s attribute."
> +msgid "The bootstrap superuser must have the %s attribute."
> msgstr "Der Bootstrap-Benutzer muss das %s-Attribut haben."
>
> No need to update the translation files. Those are updated separately in
> the pgtranslation repo.

Removed the translation changes

The attached v3 version patch has the changes for the same.

Regards,
Vignesh

Attachment Content-Type Size
v3-0001-Improve-ALTER-ROLE-documentation-to-document-curr.patch text/x-patch 3.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message vignesh C 2024-01-14 10:55:07 Re: There should be a way to use the force flag when restoring databases
Previous Message Peter Eisentraut 2024-01-14 06:32:05 Re: Escape output of pg_amcheck test