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 1rqoUt-00EBFK-9X for pgsql-docs@arkaria.postgresql.org; Sun, 31 Mar 2024 06:16:51 +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 1rqoUs-00BuXH-0V for pgsql-docs@arkaria.postgresql.org; Sun, 31 Mar 2024 06:16:50 +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 1rqoUr-00BuX8-PJ for pgsql-docs@lists.postgresql.org; Sun, 31 Mar 2024 06:16:49 +0000 Received: from mail-yw1-x1129.google.com ([2607:f8b0:4864:20::1129]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rqoUp-007lN2-DZ for pgsql-docs@postgresql.org; Sun, 31 Mar 2024 06:16:49 +0000 Received: by mail-yw1-x1129.google.com with SMTP id 00721157ae682-6147942ae15so8878567b3.3 for ; Sat, 30 Mar 2024 23:16:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1711865805; x=1712470605; darn=postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=AxYXpva+C3ixUHMAmU41qaaG2t8OQPtz9wNjoTQTSmo=; b=f/uNWBB9OFMwlUW87cm/O6h2p24pjMeycXYT6uDOrvT2ri4yy9/Wr4H5APQtgoMsJT Adnmm7vQlF9q3qy3c69zU6AzfsiNSSSLDbnZk0buhP4IBg8AQoPrh2jqkcjxHY5HPx9o 3Z+0obYuY0/0Z78dFghjwN6nNlr7UgwADDOT4= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1711865805; x=1712470605; h=user-agent:in-reply-to: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=AxYXpva+C3ixUHMAmU41qaaG2t8OQPtz9wNjoTQTSmo=; b=MAR5xH+plqUo9hv0xNsD3AboPHUMCvGzTp4Kvw+CJGM0c2RgoXbLXbH68gadptY/X/ AYuSHRTEg9K2OSR8q/uXxhfwN+gVoY3ynteVk7/CTQP82xw6d5GsaPTgELoGzpWL8eJQ nppMdk+bcghulbwHAY35y589/urcTXVdlO2WsIFFh11P9Mxg+1QYaBDQ2utU0VV1Twv/ eQem88fCfhmY3cbAUgjREDMwavy5fLDMZwkpupas23D4nqAIAr2vUP5LBd/se7aC8Rib 1BjQW/I0QH0Mam/o/gAvb8gLCJp9VQK/1/EzRgKNKOf201KlhtAVPYNmxip1k91KFE0R TOfg== X-Forwarded-Encrypted: i=1; AJvYcCUorXY4S3VAdQ+0PdGGpzAJ559jyu+hnBy+Yp6e5rvdlqhShYUwue4v/TRMMhiDAVOA/5TVB3fMzcc+X7p7Z+UEdzjehHJdav3f X-Gm-Message-State: AOJu0Yzi1sLJ5UXmeIALFkMLJU1+udKBcr1WnIcDVi/vjfW3xh/XZxwL qygaHwIx3OtvUx8VsKHAoWzJqmz44bM68WuBFIyLHEdAJEfm/xMeGodqCCCMlg== X-Google-Smtp-Source: AGHT+IFXbL7w6oX1/Pn+lti8/vBiyJK+uOdJxZQqxjuuTyGLuFlxihRZ/LM1hjA3OW51Rhzv5afrRA== X-Received: by 2002:a0d:e0c1:0:b0:611:45e9:cfa with SMTP id j184-20020a0de0c1000000b0061145e90cfamr6178510ywe.5.1711865805563; Sat, 30 Mar 2024 23:16:45 -0700 (PDT) Received: from rfd.leadboat.com ([2600:1702:a20:5750::48]) by smtp.gmail.com with ESMTPSA id v128-20020a25c586000000b00dce0f2db9acsm1513219ybe.34.2024.03.30.23.16.44 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sat, 30 Mar 2024 23:16:45 -0700 (PDT) Date: Sat, 30 Mar 2024 23:16:42 -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: <20240331061642.07@rfd.leadboat.com> References: <8e1b78c8ad45febf2e530e1f7508ee01c68bf2ef.camel@cybertec.at> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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 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? > + 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.