Horton

Re: CREATE ROLE inheritance details

Noah Misch <noah@leadboat.com>

View thread View on postgr.es
From: Noah Misch <noah@leadboat.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>, Laurenz Albe <laurenz.albe@cybertec.at>, PostgreSQL-documentation <pgsql-docs@postgresql.org>, Robert Haas <robertmhaas@gmail.com>
Date: 2024-03-31T06:16:42Z
Lists: pgsql-docs 
On Tue, Jan 30, 2024 at 01:49:42PM -0700, David G. Johnston wrote:
> +   The membership grants created by the
> +   <literal>IN ROLE</literal>, <literal>ROLE</literal>, and <literal>ADMIN</literal>
> +   clauses have the role executing this command as the grantee.

This should be s/grantee/grantor/, right?

> +   If unspecified when create a new role membership this defaults to
> +   the inheritance attribute of the role being added.

Need s/create/creating/.  Missing comma.  While phrase "role being added"
isn't wrong, the rest of the paragraph uses "member" and uses "granted role"
to refer to the member-of role.  Putting those together:

  If unspecified when creating a new role membership, this defaults to the
  inheritance attribute of the new member.

Commits

  1. Correct "improve role option documentation".

  2. Allow grant-level control of role inheritance behavior.