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 1qzvDa-0021O1-JA for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Nov 2023 08:44:22 +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 1qzvDY-00Dcab-SU for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Nov 2023 08:44:20 +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 1qzvDY-00DcaS-Dv for pgsql-hackers@lists.postgresql.org; Mon, 06 Nov 2023 08:44:20 +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 1qzvDV-004Cox-QN for pgsql-hackers@lists.postgresql.org; Mon, 06 Nov 2023 08:44:18 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-40837ebba42so26535375e9.0 for ; Mon, 06 Nov 2023 00:44:17 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1699260255; x=1699865055; 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=V0GRCVKXGQnb7UJeI88r91Ohz7iGl0Ikv0Xib/y2DSY=; b=StmLV6SEf2QkJFnfC/aIY6VfECLMqmVvmeyAjTIGwNBi8LE+ubRNzKpVektbaZ4Cfr U3mpZbl4Er2lIwx1DaNSo3nYWtSuLk6ybR3cQC7h0zQ5Zgk1Q1nf8gsvaw/QS12Gumpu BnV9LBbxRGDD64cj3JxDlCgYa9HI7xaRKFwJgwgPYB/ApVss+VY0WaXBOmpTFRrVm98/ ID9FglHRZwgq7Glmm/pFUt5/VHfDAvMRGmynZGyvihPD4Xk+hUhmfRgRRNXmOc9mNSFz GTcBCFFkJpYuIjkbHaDBbCFQq54QvJSBVj9wSdeJFwCsdXtHjt1kfMKkhaX7D4owlPVp 44ew== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699260255; x=1699865055; 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=V0GRCVKXGQnb7UJeI88r91Ohz7iGl0Ikv0Xib/y2DSY=; b=V3Fs5yGC7gRxXXc9zlxVSP+8eaSM8vD1vXywUQtpMhludvl5ksKB0uSWEh5dGqtLYB 45Z/FqWIo3oybnAPGoW/ygKw7vs0FvMo5hnrWlAGESNnI60+w59q+zzMAYZFazGxDQEs 7iU0p9h7q6FO9Eey7UYpEBR8yjrQArEktDgT331pmF1uYR8j8mBP3I3nSCig8rFhMGwD ywR6o/XdHBloDwXRaeiFL/1I2394E8rgxxpzi0qnZhacUetDma8t+rrbTEaiRYO348Iq 1Paxe817yuyqeJt6T0U3WKTWrzdlB/iyYrMKQwScYlJq5aCnuOCMSmblGlg4w2xKTXzG W0rw== X-Gm-Message-State: AOJu0Yy5/uKRpOvGHKTUWVhS+ShPqt8sIh1cbUXsl7bRqbJVpAI9TIrT 41FoUMQ5kKFgRMjJswO214NDbg== X-Google-Smtp-Source: AGHT+IG2hwSJ1v/AjKBqrXo1BtfvBT0KhjdkzrCNFWM+VBjM1slAxAlvc32rqDeL8bpOU2O8S4fZ6Q== X-Received: by 2002:a05:600c:350c:b0:409:6e0e:e95c with SMTP id h12-20020a05600c350c00b004096e0ee95cmr7727660wmq.21.1699260255440; Mon, 06 Nov 2023 00:44:15 -0800 (PST) Received: from localhost.localdomain ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id fm15-20020a05600c0c0f00b00405391f485fsm11655176wmb.41.2023.11.06.00.44.14 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 06 Nov 2023 00:44:15 -0800 (PST) Message-ID: 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: Mon, 06 Nov 2023 09:44:14 +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> <244e0f9e3300f165ff578302e942fa3145dedfc7.camel@cybertec.at> 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 21:14 -0400, Bruce Momjian wrote: > > It is not the role that is modified.=C2=A0 Perhaps: > >=20 > > =C2=A0=C2=A0 [...]; if omitted, the current role is used. >=20 > Sure, attached.=C2=A0 Here is the issue I have though, we are really not > changing default privileges for objects created in the future, we are > changing the role _now_ so future objects will have different default > privileges, right?=C2=A0 I think wording like the above is kind of odd. I see what you mean. The alternative is to be precise, at the risk of repeating ourselves: if omitted, default privileges will be changed for objects created by the current role. Yours, Laurenz Albe