Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pmXXR-0000ES-7f for pgsql-bugs@arkaria.postgresql.org; Wed, 12 Apr 2023 10:17:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pmXXQ-0001Rf-7G for pgsql-bugs@arkaria.postgresql.org; Wed, 12 Apr 2023 10:17:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pmOHS-0000hg-HO for pgsql-bugs@lists.postgresql.org; Wed, 12 Apr 2023 00:24:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pmOHP-002Kog-DU for pgsql-bugs@lists.postgresql.org; Wed, 12 Apr 2023 00:24:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=3701T/1KolF5TjAvCwZaFRZl13gBXLhB3+LxlGFCnJo=; b=N9DrI9k2c/VfY+wgg3ENnw5qje lfzHhWOHnI7lctefUZQBJktQExUyWur8Qig5Kpvf1egOqRHs4ci0oTZnXTvokxOD7YPmahDAJ2Wca GrRILNv8CO98oFudFOIb7n/uCGuD0cOUO+EbN93t7SMA+ahAJkfo2Exr7v60/TnNn3K16FXCwaA/g dU0udX6AF93x9CoTsN6XMNGB818vKIZ8AQ/oVoFdqmCFbZGL0m+o/kib66A2Ntz6mMH/15vdjnajF 3nJFnH46++kpwRUmQkHi+aXbPWSQs/mxX1RM6AGltnjIA58LImoaLTNiz86QVZblGhnITjoQWk24N IALGUUlw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pmOHN-00022S-Uf for pgsql-bugs@lists.postgresql.org; Wed, 12 Apr 2023 00:24:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pmOHL-0098Le-8r for pgsql-bugs@lists.postgresql.org; Wed, 12 Apr 2023 00:24:03 +0000 Content-Type: multipart/mixed; boundary="===============4297399625389075743==" MIME-Version: 1.0 Subject: BUG #17891: MAIF - Strange behavior on Grants with Groups To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: smartkeyerror@gmail.com Reply-To: smartkeyerror@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 12 Apr 2023 00:23:52 +0000 Message-ID: <17891-8d38a1fb993f6d57@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4297399625389075743== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzg5MQpMb2dnZWQgYnk6ICAgICAgICAgIHNtYXJ0a2V5ZXJyb3IKRW1h aWwgYWRkcmVzczogICAgICBzbWFydGtleWVycm9yQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDE1LjAKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKClNjaGVtYXMsIHRhYmxlIGFuZCB2aWV3Og0KDQpJIGNyZWF0ZWQgMiBzY2hlbWFzOiAN Cg0KMSB0YWJsZSBpbiB0aGUgMXN0IHNjaGVtYSBhbmQgYSB2aWV3IGluIHRoZSAybmQgc2NoZW1h ICh0aGUgdmlldyBpcyBhIHNpbXBsZQpzZWxlY3Qgb24gdGhlIHRhYmxlKQ0KDQpHcm91cHM6DQoN CkkgY3JlYXRlZCA0IGdyb3VwczoNCg0KZm9yIGVhY2ggc2NoZW1hLCB0aGVyZSBpcyBhIGdyb3Vw IGZvciBvd25lcnMgKG5hbWUgc3RhcnRlZCBieSBnb18pIGFuZCBhCmdyb3VwIGZvciByZWFkZXJz IChuYW1lIHN0YXJ0ZWQgYnkgZ3JfKQ0KDQp0aGUgdGFibGUgaW4gdGhlIDFzdCBzY2hlbWEgaXMg b3duZWQgYnkgYSBncm91cCBvd25lciAoZGVkaWNhdGVkIGZvciB0aGUKc2NoZW1hKQ0KDQp0aGUg dmlldyBpbiB0aGUgMm5kIHNjaGVtYSBpcyBvd25lZCBieSB0aGUgb3RoZXIgZ3JvdXAgb3duZXIN Cg0KVXNlciBhbmQgR3JhbnRzOg0KDQpJIGNyZWF0ZWQgYSB1c2VyIHNhc19sZWN0IGluIHRoZSAy IGdyb3VwcyBmb3IgcmVhZGVycyAoZ3JfKikNCg0KSSBnYXZlIFNFTEVDVCBncmFudCBvbiB0aGUg Z3JvdXBzIGZvciByZWFkZXJzDQoNCldpdGggdGhlIHVzZXIgc2FzX2xlY3QsIHdoZW4gSSB0cnkg dG8gc2VsZWN0IHRoZSB0YWJsZSwgaXQgd29ya3MNCg0KV2hlbiBJIHRyeSB0byBzZWxlY3QgdGhl IHZpZXcsIGl0IGZhaWxzOiBwZXJtaXNzaW9uIGRlbmllZCBvbiB0aGUgdGFibGUNCg0KSWYgSSBy ZW1vdmUgdGhlIGdyb3VwIG93bmVyIGZyb20gdGhlIHRhYmxlIGFuZCB0aGUgdmlldywgKHB1dCBi YWNrIGdwYWRtaW4KYXMgb3duZXIpOg0KDQpXaXRoIHRoZSB1c2VyIHNhc19sZWN0LCB3aGVuIEkg dHJ5IHRvIHNlbGVjdCB0aGUgdGFibGUsIGl0IHdvcmtzDQoNCldoZW4gSSB0cnkgdG8gc2VsZWN0 IHRoZSB2aWV3LCBpdCB3b3Jrcw0KDQoNCmBgYA0KY3JlYXRlIHVzZXIgc2FzX2xlY3QgcGFzc3dv cmQgJzEyMyc7DQpjcmVhdGUgdXNlciBzYXNfb3duZXIgcGFzc3dvcmQgJzEyMyc7DQoNCmNyZWF0 ZSByb2xlIGdyX3phX2lmc19kYXRhOw0KY3JlYXRlIHJvbGUgZ29femFfaWZzX2RhdGE7DQoNCmNy ZWF0ZSByb2xlIGdyX3pwX2lmc192aWV3czsNCmNyZWF0ZSByb2xlIGdvX3pwX2lmc192aWV3czsN Cg0KZ3JhbnQgZ3JfemFfaWZzX2RhdGEgdG8gc2FzX2xlY3Q7DQpncmFudCBncl96cF9pZnNfdmll d3MgdG8gc2FzX2xlY3Q7DQoNCmdyYW50IGdvX3phX2lmc19kYXRhIHRvIHNhc19vd25lcjsNCmdy YW50IGdvX3pwX2lmc192aWV3cyB0byBzYXNfb3duZXI7DQoNCi0tIENyZWF0ZSAyIHNjaGVtYXMN Cg0KZHJvcCBzY2hlbWEgaWYgZXhpc3RzIHphX2lmc19kYXRhIGNhc2NhZGU7DQpjcmVhdGUgc2No ZW1hIHphX2lmc19kYXRhOw0KZHJvcCBzY2hlbWEgaWYgZXhpc3RzIHpwX2lmc192aWV3cyBjYXNj YWRlOw0KY3JlYXRlIHNjaGVtYSB6cF9pZnNfdmlld3M7DQoNCmFsdGVyIHNjaGVtYSB6YV9pZnNf ZGF0YSBvd25lciB0byBnb196YV9pZnNfZGF0YTsNCmFsdGVyIHNjaGVtYSB6cF9pZnNfdmlld3Mg b3duZXIgdG8gZ29fenBfaWZzX3ZpZXdzOw0KDQpncmFudCB1c2FnZSBvbiBzY2hlbWEgemFfaWZz X2RhdGEgdG8gZ3JfemFfaWZzX2RhdGE7DQpncmFudCB1c2FnZSBvbiBzY2hlbWEgenBfaWZzX3Zp ZXdzIHRvIGdyX3pwX2lmc192aWV3czsNCg0KLS0gQ3JlYXRlIDEgdGFibGUgaW4gdGhlIDFzdCBz Y2hlbWEgYW5kIDEgdmlldyBvbiB0aGUgcHJldmlvdXMgdGFibGUgaW4gdGhlCjJuZCBzY2hlbWEN Cg0KZHJvcCB0YWJsZSBpZiBleGlzdHMgemFfaWZzX2RhdGEudDEgY2FzY2FkZTsNCmNyZWF0ZSB0 YWJsZSB6YV9pZnNfZGF0YS50MSAoYSBpbnQpOw0KaW5zZXJ0IGludG8gemFfaWZzX2RhdGEudDEg c2VsZWN0IGdlbmVyYXRlX3NlcmllcygxLDMpOw0KYWx0ZXIgdGFibGUgemFfaWZzX2RhdGEudDEg b3duZXIgdG8gZ29femFfaWZzX2RhdGE7DQoNCmRyb3AgdmlldyBpZiBleGlzdHMgenBfaWZzX3Zp ZXdzLnQxX3ZpZXc7DQpjcmVhdGUgdmlldyB6cF9pZnNfdmlld3MudDFfdmlldyBhcyBzZWxlY3Qg KiBmcm9tICB6YV9pZnNfZGF0YS50MTsNCmFsdGVyIHZpZXcgenBfaWZzX3ZpZXdzLnQxX3ZpZXcg b3duZXIgdG8gZ29fenBfaWZzX3ZpZXdzOw0KDQotLSBHaXZlIFNFTEVDVCBncmFudCBvbiB0aGUg dGFibGUgYW5kIHRoZSB2aWV3DQoNCmdyYW50IHNlbGVjdCBvbiB0YWJsZSB6YV9pZnNfZGF0YS50 MSB0byBncl96YV9pZnNfZGF0YTsNCmdyYW50IHNlbGVjdCBvbiB0YWJsZSB6cF9pZnNfdmlld3Mu dDFfdmlldyB0byBncl96cF9pZnNfdmlld3M7DQoNCi0tIENoZWNrIHRoZSBTRUxFQ1QgIGdyYW50 cw0KDQpzZWxlY3QgKg0KZnJvbSBpbmZvcm1hdGlvbl9zY2hlbWEudGFibGVfcHJpdmlsZWdlcyBw cml2DQp3aGVyZSBwcml2LnByaXZpbGVnZV90eXBlID0gJ1NFTEVDVCcNCmFuZCB0YWJsZV9zY2hl bWEgaW4gKCd6YV9pZnNfZGF0YScsJ3pwX2lmc192aWV3cycpOw0KDQpcZHUrIHNhc19sZWN0DQoN ClxkcCsgemFfaWZzX2RhdGEudDE7DQpcZHArIHpwX2lmc192aWV3cy50MV92aWV3Ow0KDQotLSBD aGVjayBTRUxFQ1Qgb24gdGhlIHRhYmxlIGFuZCB0aGUgdmlldyBmb3IgdGhlIHVzZXIgc2FzX2xl Y3QNCnNlbGVjdCAqIGZyb20gemFfaWZzX2RhdGEudDE7DQpzZWxlY3QgKiBmcm9tIHpwX2lmc192 aWV3cy50MV92aWV3Ow0KDQotLSBDaGFuZ2Ugb3duZXJzIG9mIHRoZSB0YWJsZSBhbmQgdGhlIHZp ZXcNCmFsdGVyIHRhYmxlIHphX2lmc19kYXRhLnQxIG93bmVyIHRvIGdwYWRtaW47DQphbHRlciB2 aWV3IHpwX2lmc192aWV3cy50MV92aWV3IG93bmVyIHRvIGdwYWRtaW47DQoNCi0tIENoZWNrIFNF TEVDVCBvbiB0aGUgdGFibGUgYW5kIHRoZSB2aWV3IGZvciB0aGUgdXNlciBzYXNfbGVjdA0Kc2Vs ZWN0ICogZnJvbSB6YV9pZnNfZGF0YS50MTsNCnNlbGVjdCAqIGZyb20genBfaWZzX3ZpZXdzLnQx X3ZpZXc7DQpgYGAKCg== --===============4297399625389075743==--