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 1qzNwo-00FwNf-7R for pgsql-hackers@arkaria.postgresql.org; Sat, 04 Nov 2023 21:12:50 +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 1qzNwl-007PBj-T1 for pgsql-hackers@arkaria.postgresql.org; Sat, 04 Nov 2023 21:12:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qzNwl-007PBb-JZ for pgsql-hackers@lists.postgresql.org; Sat, 04 Nov 2023 21:12:47 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qzNwi-003ykh-Q7 for pgsql-hackers@lists.postgresql.org; Sat, 04 Nov 2023 21:12:46 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-40806e4106dso19452935e9.1 for ; Sat, 04 Nov 2023 14:12:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1699132363; x=1699737163; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=avtmcwaXnmEAgTthfSJoOnZ2kE3uDMNLqSJObT000bY=; b=DaPlBmyRgbzS7piTfGlHyJ8i0ZOJUtYEzeOieM+vTtP+CKi32EpYMq/jEhVv3RWe9I qgCz7MVyc2+sdA5vXkR7qOVGGGFtf6xE0OMnI0s69udC0qul7fZGvVHcRwb2vFPZ8WP6 N1LscdVHy+4qKrPjlZGtXfu39A0Ij0xfZo6euPPSZ8H3PIqjqMS1kZIQ6Hv/rzmjPlX3 U8iICUNiBuWyInPpLgUCftAKKHeNc5IWiIDwIUgbhapvaU2pBalFYqdbcen5U/+nL/Ya iBRGqtIRY9O2qcsvLe2kIOahLjYR9tzpbj85+CvnK43ng+7ukrgvaRqdnsOlv5tjQi+v kcMQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699132363; x=1699737163; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=avtmcwaXnmEAgTthfSJoOnZ2kE3uDMNLqSJObT000bY=; b=QSeJSlorFzoH30JfqoLkVBcWqVpzcbDqZVvNC5j10xvHf4hfwoy19q6/Ff8Ygmp+/B ooSKvRG3AVowrN+AG7+E1eSf7IM+9AhRGPx1KDtas1VtpR+gsn7JnYcfUhMpZyFeAx96 L6+m8PRnGtrbC0wqatV+U/yPbj4Zd7OXVAQwQCmPEoSABx/MAelvSBKIkyLA+XnWh44P 2xufeQXh+b7KzLSAc6OZtUTIJtxaZS1kFRqfdmXtq3dDSCUsZKqjK+ekxWwkGS2evmdQ hciHBMuV9bnXDAQHZPI7mmkxHKHfM5+EAu8ZWxsw/4+mvFaZAQ+etb2fZrzfmG/U6oF+ Zxuw== X-Gm-Message-State: AOJu0YwEUjBVCkO2reevzyg9qV7E4WFwtPK9OtcicpHBS785jqR7Xfey WgVpARLX75MdiqjRqTlPkeJ8Qw== X-Google-Smtp-Source: AGHT+IFgLRUFeEQImNr08t3a0ypYowS/tKkB9l8BgOPlMGy9m7QXGjz7PL2mlT/kVBkSVu58aNrLsg== X-Received: by 2002:a05:600c:4f06:b0:402:e68f:8a4f with SMTP id l6-20020a05600c4f0600b00402e68f8a4fmr7043607wmq.0.1699132363248; Sat, 04 Nov 2023 14:12:43 -0700 (PDT) Received: from localhost.localdomain ([2001:871:260:349a:57ab:e7ee:d613:d164]) by smtp.gmail.com with ESMTPSA id gy14-20020a05600c880e00b00403b63e87f2sm6707853wmb.32.2023.11.04.14.12.42 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 04 Nov 2023 14:12:42 -0700 (PDT) Message-ID: <244e0f9e3300f165ff578302e942fa3145dedfc7.camel@cybertec.at> Subject: Re: Version 14/15 documentation Section "Alter Default Privileges" From: Laurenz Albe To: Bruce Momjian Cc: Michael Banck , David Burns , pgsql-hackers@lists.postgresql.org Date: Sat, 04 Nov 2023 22:12:42 +0100 In-Reply-To: References: <4a6f157edc4ae38a2050a5893e6729cbb98113bc.camel@cybertec.at> <653b841d.a70a0220.17f72.2c12@mx.google.com> <7de5f33f49a91d7b30b8c01fe46fc280713ebae1.camel@cybertec.at> <653cce08.050a0220.a10fb.7878@mx.google.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, 2023-11-04 at 14:20 -0400, Bruce Momjian wrote: > Yes, I see your point. Updated patch attached. Almost perfect, except: + Change default privileges for objects created by + target_role; if omitted, the current + role is modified. It is not the role that is modified. Perhaps: [...]; if omitted, the current role is used. Yours, Laurenz Albe