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 1qzv29-0020GX-Tz for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Nov 2023 08:32:33 +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 1qzv28-00DWm2-66 for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Nov 2023 08:32:32 +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 1qzv27-00DWlu-SA for pgsql-hackers@lists.postgresql.org; Mon, 06 Nov 2023 08:32:31 +0000 Received: from mail-wr1-x42b.google.com ([2a00:1450:4864:20::42b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qzv26-004xuM-93 for pgsql-hackers@lists.postgresql.org; Mon, 06 Nov 2023 08:32:31 +0000 Received: by mail-wr1-x42b.google.com with SMTP id ffacd0b85a97d-32d849cc152so2898799f8f.1 for ; Mon, 06 Nov 2023 00:32:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1699259549; x=1699864349; darn=lists.postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :subject:cc:to:from:date:sender:message-id:from:to:cc:subject:date :message-id:reply-to; bh=uSVPoEuFNUsjkqphvTKRPOON6C7/9NrUC4hGm3d6XG0=; b=fBASGMhtD0daV9d6x1oxySyyK95PyjEJDbaYeysfla69iSL4p8IvuOg34ab9px51pY LBVvXQ0s/YGIubNW3ztoGsOtAxUIm6ixbCAxiUj8ZeDOeOObli3OtObspEdd1elmYCqH gqW6O4xkLQNLgR5+7m5Ir3zJh+xKVxo4OmEe/4AzcG7M4RxL9DeOcKk2RhGISFUvhe/b AdhTWfDeXQciVVmNfU/uHGlevTXYAZVXug1XfS5XIbjZ1ARJN5KDpdtbe/p31RuRnVIp xSVvIhM3bI1eyzmQEsel/UWY5545NvMil+1tzAM7ib9ykxdIPittZurw0uHs3R/8fr7N 0TWw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699259549; x=1699864349; h=user-agent:in-reply-to:content-disposition:mime-version:references :subject:cc:to:from:date:sender:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=uSVPoEuFNUsjkqphvTKRPOON6C7/9NrUC4hGm3d6XG0=; b=WwL55xHzWHBQTSVvbiCYP8gSmRwtJsZ4Ex9QkorXTRkzBtnZTaE13cyh/zbPXqRPBf cl2JCaIm8xlm2ZAWpEpcAOHZ8iOOoxam0Cn4dlXMiIgimHiAiAUJsrjbr9hxdNwRoIj/ JIuDpOd+lhaItjhwbJHsQLV0XiM8/BiC4gNJE3kbyPhs9aYyxPAvEUs3FuatTZBfg9C/ o8i17yDtU4zlQf3oTMZUf+zGyOHI588fIRQWP/XIo177tk0mTd8ccgMALqc0BbsE5b6d XWQzm6QQDOTlO1wi//o53g68msnNTOoiAmJ/gQE5IONR7JOpooDHcY1A5PR07JmudSUP id8g== X-Gm-Message-State: AOJu0YwkDTDc13uyENDbS8sw30kJlfyc5EL4vedkClLGNI9/IRX5WRUj hnOWq0ebVF9VMX+//62yWMM= X-Google-Smtp-Source: AGHT+IHD0fSNx4UoXS/8QauUui/ZgzYU+VKszBsAH65K7uJhg5LyaQd/8CYYdPcT20rQl2tUK9KCWA== X-Received: by 2002:a5d:568a:0:b0:32d:adda:e8cd with SMTP id f10-20020a5d568a000000b0032daddae8cdmr22039422wrv.22.1699259549165; Mon, 06 Nov 2023 00:32:29 -0800 (PST) Received: from lightning.caipicrew.dd-dns.de ([2001:a61:34cf:1001:f11c:3b32:31b7:711]) by smtp.gmail.com with ESMTPSA id t6-20020a5d49c6000000b0031aef72a021sm8730203wrs.86.2023.11.06.00.32.28 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 06 Nov 2023 00:32:28 -0800 (PST) Message-ID: <6548a49c.5d0a0220.ced36.ca65@mx.google.com> X-Google-Original-Message-ID: <20231106083227.GA25804@caipicrew.dd-dns.de;lightning.caipicrew.dd-dns.de> Sender: Michael Banck Received: from mbanck by lightning.caipicrew.dd-dns.de with local (Exim 4.92) (envelope-from ) id 1qzv24-0004i5-0J; Mon, 06 Nov 2023 09:32:28 +0100 Date: Mon, 6 Nov 2023 09:32:27 +0100 From: Michael Banck To: Bruce Momjian Cc: Laurenz Albe , David Burns , pgsql-hackers@lists.postgresql.org Subject: Re: Version 14/15 documentation Section "Alter Default Privileges" References: <653b841d.a70a0220.17f72.2c12@mx.google.com> <7de5f33f49a91d7b30b8c01fe46fc280713ebae1.camel@cybertec.at> <653cce08.050a0220.a10fb.7878@mx.google.com> <244e0f9e3300f165ff578302e942fa3145dedfc7.camel@cybertec.at> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Sat, Nov 04, 2023 at 09:14:01PM -0400, Bruce Momjian wrote: > + There is no way to change the default privileges for objects created by > + any role. You have run ALTER DEFAULT PRIVILEGES for all > + roles that can create objects whose default privileges should be modified. That second sentence is broken, it should be "You have to run [...]" I think. Michael