Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rvesD-00DPBc-99 for pgsql-docs@arkaria.postgresql.org; Sat, 13 Apr 2024 15:00:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rvesC-004l75-3q for pgsql-docs@arkaria.postgresql.org; Sat, 13 Apr 2024 15:00:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rvesB-004l6w-Ko for pgsql-docs@lists.postgresql.org; Sat, 13 Apr 2024 15:00:55 +0000 Received: from mail-yw1-x1132.google.com ([2607:f8b0:4864:20::1132]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rves8-000kGr-F3 for pgsql-docs@postgresql.org; Sat, 13 Apr 2024 15:00:55 +0000 Received: by mail-yw1-x1132.google.com with SMTP id 00721157ae682-61874a5b8ecso17649807b3.0 for ; Sat, 13 Apr 2024 08:00:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1713020451; x=1713625251; darn=postgresql.org; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:message-id:subject:cc :to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=eqtjwlB7v6myV1jiNao4t16F75cnqDfaZILkWtTIwJ4=; b=XUuVgfsAH4Ve3rOzQ6vmkxyAuK+9s2UAiVX6nNVP6QxkpXWKkioPyyHip8aW/jLGom jC7216ad0NXJThloh9vI25DKB/PtJtdsXBwJLN4C4wa92bGzlWelq2apF8AUKKNMTYJI cnXfm9uSMfptFmN///EylINZFzuq89Htx+L3s= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1713020451; x=1713625251; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:message-id:subject:cc :to:from:date:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=eqtjwlB7v6myV1jiNao4t16F75cnqDfaZILkWtTIwJ4=; b=M28ExMN3Y2RBREjY/ftkiyKu4tEIyMuETMRDYZeMmv2ntdo9ABQ7qzFQQlCUsPVmnK sSGZ7jEl4uyFOLizt3nPGYATMUce0PwdWFOpukqGY6YBrMl9v4oDC6mpBtN2875E1xkS EUjyZ9Obfe6LyGFVXXHa5mdfUwTZaVg5f1zmx1zpME+Ztjws02mKz8HMjH9JK8lGQPkp VMLbJDKgBta+SHGM3+aKo0acjgNDEgQXJAek1Mcbke2Exq1dF+E9NdkXuhsY9QKtFcwu WVyF5dUt5qyxvDAxDLFV8YNTCM+TWiQQ4t1+iNcN0Fru+0HZPHVJENzRcVU+uNkBT/+d nSmg== X-Forwarded-Encrypted: i=1; AJvYcCU7d3zrbJrlT6/1lwnrT2nyfa5r/IbsWiSDWvwTMiHXTbtAGTYT2ThH9Zy7RqKbJZF3qjM1/IJnbhBGAROZ2lzSbEwHFmBGLzyf X-Gm-Message-State: AOJu0YxqDTwSwh/oRohO6zAeAc5ZR00y8Od0ppmbJGZvgKUIe91H7OJw 6xgQNBOFiC3d0gn92cRKETZINz/VZQnmwfe9vp/YR9FStl2zkeyECtTdMg5Z6Q== X-Google-Smtp-Source: AGHT+IFKmTSy4lOC328eNhoIFASa6fWTwLxOxyunPwYCz4pVjUyHEg7D9pu6Nb+J4pgyCecHtcwwjA== X-Received: by 2002:a81:4850:0:b0:615:e8f:2f4f with SMTP id v77-20020a814850000000b006150e8f2f4fmr5574318ywa.17.1713020450852; Sat, 13 Apr 2024 08:00:50 -0700 (PDT) Received: from rfd.leadboat.com ([2600:1702:a20:5750::48]) by smtp.gmail.com with ESMTPSA id y77-20020a81a150000000b00617c94aaea3sm1276619ywg.70.2024.04.13.08.00.49 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sat, 13 Apr 2024 08:00:50 -0700 (PDT) Date: Sat, 13 Apr 2024 08:00:47 -0700 From: Noah Misch To: "David G. Johnston" Cc: Bruce Momjian , Laurenz Albe , PostgreSQL-documentation , Robert Haas Subject: Re: CREATE ROLE inheritance details Message-ID: <20240413150047.50@rfd.leadboat.com> References: <8e1b78c8ad45febf2e530e1f7508ee01c68bf2ef.camel@cybertec.at> <20240331061642.07@rfd.leadboat.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Apr 03, 2024 at 06:11:47PM -0700, David G. Johnston wrote: > On Sat, Mar 30, 2024 at 11:16 PM Noah Misch wrote: > > On Tue, Jan 30, 2024 at 01:49:42PM -0700, David G. Johnston wrote: > > > + The membership grants created by the > > > + IN ROLE, ROLE, and > > ADMIN > > > + clauses have the role executing this command as the grantee. > > > > This should be s/grantee/grantor/, right? > > Correct. > > > > + 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. > > I like that better. Pushed as 68ba46d. Thanks for reviewing.