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 1rk3dv-00A04B-KW for pgsql-bugs@arkaria.postgresql.org; Tue, 12 Mar 2024 15:02:16 +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 1rk3du-00EC5X-52 for pgsql-bugs@arkaria.postgresql.org; Tue, 12 Mar 2024 15:02:14 +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 1rk2Xy-00D3zr-M7 for pgsql-bugs@lists.postgresql.org; Tue, 12 Mar 2024 13:52:03 +0000 Received: from mx0b-000e5c01.pphosted.com ([67.231.157.188]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rk2Xu-0047dO-0p for pgsql-bugs@lists.postgresql.org; Tue, 12 Mar 2024 13:52:01 +0000 Received: from pps.filterd (m0146461.ppops.net [127.0.0.1]) by mx0b-000e5c01.pphosted.com (8.17.1.19/8.17.1.19) with ESMTP id 42CDVqxU031418; Tue, 12 Mar 2024 09:51:50 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=evernorth.com; h=from : to : date : message-id : references : in-reply-to : content-type : content-transfer-encoding : mime-version : subject; s=pod011016231234; bh=93yrIsMcdErg9BfrLeA5/xl/7Kgwe70WIa6PjikoGEc=; b=V0rViW0YzPAmuUaPwanJm17C3jOJOAFM/j5mqStHWuYeu7P0xIGjrdPKcFOUpchPKD7t 1GLTYQrTRhpqPb4TlebfCjwxRzEPLlvj0XOJQ2PdVa0m+McRNQ34yX5+WngrAD2Sz5Jx zmwVRdM+EtF8ucxqFXn+s+YRz/P2pGKYVIbVDoD8EccdRSy4bjleylfScrmg6vUcE9rf utlJGclFh66J8Xb8VHLsl9kDY4m9sb1SUYw+qlZzLIe9AKJ1j2Y+IsjHx7mGOC0myOsk vOhnM7IF1Jtb0vApqacp7Gk41gdZMQhM/Wd+60VrjCAWwUJkRZAc4UOPKEOQY85llBWC Jw== Received: from express-scripts.com (mx0a-000e5c14.pphosted.com [148.163.133.209]) by mx0b-000e5c01.pphosted.com (PPS) with ESMTPS id 3wtr0fg2gq-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Tue, 12 Mar 2024 09:51:50 -0400 Received: from m0206227.ppops.net (m0206227.ppops.net [127.0.0.1]) by pps.cigna (8.17.1.5/8.17.1.5) with ESMTP id 42CDpntl009027; Tue, 12 Mar 2024 08:51:49 -0500 Received: from pps.reinject (localhost [127.0.0.1]) by mx0a-000e5c14.pphosted.com (PPS) with ESMTPS id 3wrkghd5hg-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Tue, 12 Mar 2024 08:51:49 -0500 Received: from m0206227.ppops.net (m0206227.ppops.net [127.0.0.1]) by pps.reinject (8.17.1.5/8.17.1.5) with ESMTP id 42CDpmNn009014; Tue, 12 Mar 2024 08:51:48 -0500 Received: from eiaappxp0010.gid.prd.globalcore.com (lyncav03.cigna.com [170.48.19.149] (may be forged)) by mx0a-000e5c14.pphosted.com (PPS) with ESMTPS id 3wrkghd5hd-2 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Tue, 12 Mar 2024 08:51:48 -0500 Received: from cvlappxp20755.internal.cigna.com (HELO PS2PW1012185.accounts.root.corp) ([10.36.52.91]) by EIAAPPXP0010.gid.prd.globalcore.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 12 Mar 2024 13:51:48 +0000 Received: from PS2PW1012186.accounts.root.corp (10.221.225.154) by PS2PW1012185.accounts.root.corp (10.221.225.153) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1258.27; Tue, 12 Mar 2024 09:51:46 -0400 Received: from PS2PW1012186.accounts.root.corp ([fe80::9fec:fffb:1381:33ad]) by PS2PW1012186.accounts.root.corp ([fe80::9fec:fffb:1381:33ad%6]) with mapi id 15.02.1258.027; Tue, 12 Mar 2024 09:51:46 -0400 From: "Wetmore, Matthew (CTR)" To: Laurenz Albe , Heikki Linnakangas , "maxim.boguk@gmail.com" , "pgsql-bugs@lists.postgresql.org" Thread-Topic: [EXTERNAL] Re: BUG #18387: Erroneous permission checks and/or misleading error messages with refresh materialized view Thread-Index: AQHadAgv42W/njllWEeGqp84mMOJzLEz+nkAgAAlgmA= Date: Tue, 12 Mar 2024 13:51:46 +0000 Message-ID: References: <18387-12041858d9efb6f6@postgresql.org> <36bb333d-13ec-4f8e-af33-48249ca2fe69@iki.fi> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.221.252.1] x-proofpoint-routing: 000e5c14 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-CFilter-Loop: Reflected Subject: BUG #18387: Erroneous permission checks and/or misleading error messages with refresh materialized view X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.272,Aquarius:18.0.1011,Hydra:6.0.619,FMLib:17.11.176.26 definitions=2024-03-12_08,2024-03-12_01,2023-05-22_02 X-Proofpoint-GUID: x_I2P14ta1vuuHuBJ4ZzcIPThVmynZEP X-Proofpoint-ORIG-GUID: x_I2P14ta1vuuHuBJ4ZzcIPThVmynZEP X-Connecting-IP: 148.163.133.209 X-External-Mail: True X-Content-Length: 4239 X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.272,Aquarius:18.0.1011,Hydra:6.0.619,FMLib:17.11.176.26 definitions=2024-03-12_08,2024-03-12_01,2023-05-22_02 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 priorityscore=1501 impostorscore=0 mlxscore=0 mlxlogscore=829 malwarescore=0 adultscore=0 bulkscore=0 phishscore=0 suspectscore=0 lowpriorityscore=0 clxscore=1011 spamscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2311290000 definitions=main-2403120106 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk IA0KPiBJIGd1ZXNzIHdlIG5lZWQgdG8gYWxsb3cgY3JlYXRpbmcgc3VjaCBpbnRlcm5hbCB0ZW1w b3JhcnkgdGFibGVzLCANCj4gZGVzcGl0ZSB0aGUgbWlzc2luZyBwZXJtaXNzaW9uLiBUaGF0J2xs IG5lZWQgc29tZSBjYXJlZnVsIGFuYWx5c2lzIHRvIA0KPiBtYWtlIHN1cmUgd2UgZG9uJ3QgYWNj aWRlbnRhbGx5IGFsbG93IGNyZWF0aW5nIG90aGVyIHRlbXBvcmFyeSB0YWJsZXMuLi4NCg0KV291 bGRuJ3QgaXQgYmUgc3VmZmljaWVudCB0byBkb2N1bWVudCB0aGF0IGZhY3QsIHBlcmhhcHMgYWRk IGFuIGVycm9yIGhpbnQgYW5kIHJlcXVpcmUgdGhlIE1WIG93bmVyIHRvIGhhdmUgVEVNUCBvbiB0 aGUgZGF0YWJhc2U/DQoNClRoYXQncyBub3QgYW4gb3V0cmFnZW91cyByZXF1aXJlbWVudCwgYW5k IGl0IGNvdWxkbid0IG9wZW4gYW55IHNlY3VyaXR5IGJhY2sgZG9vcnMuDQoNCg0KQWdyZWUuIFdl IGFscmVhZHkgaGF2ZSB0byBjcmVhdGUgYSBuZXcgdXNlciAod2VsbCwgdGhhdOKAmXMgd2hhdCBJ IGRvKSBmb3IgTVYncyBhbnl3YXkgZm9yIHRoZSBSRUZSRVNIIGJ5IG93bmVyIG9ubHksIGl0IHdv dWxkIG5vdCBiZSBhIGJ1cmRlbiB0byBhZGp1c3QgdGhhdCBST0xFJ3Mgc2V0dGluZ3MgYXQgdGlt ZSBvZiBjcmVhdGlvbi4gIFRoZSBkb2NvIGlzIGNvbXBsZXRlbHkgY2xlYXIgYWJvdXQgTVYgb3du ZXIsIHdlIGNhbiBqdXN0IGFkZCB0byB0aGF0IG5vdGUgdG8gbWFrZSBzdXJlIENSRUFURSBwZXJt aXNzaW9uIHRvby4NCg0K