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 1qzwvU-002Be3-Kx for pgsql-bugs@arkaria.postgresql.org; Mon, 06 Nov 2023 10:33:48 +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 1qzwvT-00EJuH-2t for pgsql-bugs@arkaria.postgresql.org; Mon, 06 Nov 2023 10:33:47 +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 1qzwsx-00EH6w-Po for pgsql-bugs@lists.postgresql.org; Mon, 06 Nov 2023 10:31:11 +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 1qzwsr-004yqg-9M for pgsql-bugs@lists.postgresql.org; Mon, 06 Nov 2023 10:31:11 +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=ItKFlKyQ07S5hV+iT1L2XwYPMEseKl7n/8gAx4S43Ig=; b=osDyGHlP/0SDWqHn+3Tbc8Ajp9 QvuZ1XxSxfLrlEuuuZ7DdUpDgQhWBNSHQyA+2FJfHGIs26vs6h9vhOddNYmyYqwiCcMIThivZ3FNp dDMJdPTQEXYxVi25J8tfsXuLlEpbBlIpiJU8mf2vmVqH/zE2NyyRbx65DV6L8qLYtN00148AgWtS0 pPGumDNdpohDverHEu276e8VzoKj8gdyEeuDQRuxnD4YnLqigQJNFLFnUENrE7NPrKQsMlqDoGMWP 1XrB8AiNu0mgUMCX7qZzMOUtgWZhECi+48TLrbvFumXK7g8lIvkYVoSZGzmmfV7z1Cv9lSczuT/zC bpbxNJaw==; 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 1qzwsp-0005Jo-RF for pgsql-bugs@lists.postgresql.org; Mon, 06 Nov 2023 10:31:03 +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 1qzwsn-00FzJe-05 for pgsql-bugs@lists.postgresql.org; Mon, 06 Nov 2023 10:31:02 +0000 Content-Type: multipart/mixed; boundary="===============8927950658377631588==" MIME-Version: 1.0 Subject: BUG #18183: Unable to grant similar roles after changing user from No inheritance to Inheritance. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: riyaz489.rk@gmail.com Reply-To: riyaz489.rk@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 06 Nov 2023 10:30:49 +0000 Message-ID: <18183-2d377c717b5cfcce@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 --===============8927950658377631588== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE4MwpMb2dnZWQgYnk6ICAgICAgICAgIFJpeWF6IEtoYW4KRW1haWwg YWRkcmVzczogICAgICByaXlhejQ4OS5ya0BnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Ni4wCk9wZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cwpEZXNjcmlwdGlvbjogICAgICAgIAoKREJf bmFtZSAgPSB0ZXN0DQoNCkkgaGF2ZSBjcmVhdGVkIGEgbmV3IHVzZXIgJ3QxJyBhbmQgTm93IEkg d2FudCB0byBncmFudCBhbGwgcGVybWlzc2lvbiBvZiBteQpleGlzdGluZyB1c2VyICd0ZXN0JyB0 byB0aGlzIG5ldyB1c2VyICd0MScuDQpUbyBkbyBTbyBJIHJhbiB0aGUgbWVudGlvbmVkIGNvbW1h bmQ6DQpncmFudCB0ZXN0IHRvIHQxOw0KDQpidXQgZXZlbiBhZnRlciB0aGF0LCBJIG5vdGljZWQg J3QxJyBkaWRuJ3QgZ2V0IGFueSByZXF1aXJlZCBwZXJtaXNzaW9ucy4NClNvIEFmdGVyIHRoYXQs IEkgcmFuIFxkdSBjb21tYW5kIGFuZCBjaGVja2VkIHJvbGVzIHRhYmxlIHRvIHZlcmlmeSB0MQpw ZXJtaXNzaW9ucywgYW5kIEkgZ290IHRoaXMgb3V0cHV0IA0KDQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgIExpc3Qgb2Ygcm9sZXMNCiBSb2xlIG5hbWUgfCAgICAgICAgICAgICAgICAgICAg ICAgICBBdHRyaWJ1dGVzDQotLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiB0MSAgICAgICAgfCBObyBpbmhlcml0 YW5jZQ0KIHRlc3QgICAgICB8IFN1cGVydXNlciwgQ3JlYXRlIHJvbGUsIENyZWF0ZSBEQiwgUmVw bGljYXRpb24sIEJ5cGFzcyBSTFMNCg0KDQp0ZXN0PSMgc2VsZWN0IHJvbG5hbWUgZnJvbSBwZ191 c2VyIGpvaW4gcGdfYXV0aF9tZW1iZXJzIG9uCihwZ191c2VyLnVzZXN5c2lkPXBnX2F1dGhfbWVt YmVycy5tZW1iZXIpIGpvaW4gcGdfcm9sZXMgb24KKHBnX3JvbGVzLm9pZD1wZ19hdXRoX21lbWJl cnMucm9sZWlkKSB3aGVyZSBwZ191c2VyLnVzZW5hbWU9J3QxJzsNCg0KIHJvbG5hbWUNCi0tLS0t LS0tLQ0KIHRlc3QNCg0KQWZ0ZXIgdGhpcywgSSByYW4gdGhlIGJlbG93IGNvbW1hbmQgdG8gcHJv dmlkZSBpbmhlcml0IGFjY2VzcyB0byB1c2VyIHQxOw0KDQp0ZXN0PSMgYWx0ZXIgdXNlciB0MSB3 aXRoIGluaGVyaXQ7DQpBTFRFUiBST0xFDQoNCnRoaXMgY29tbWFuZCBzdWNjZXNzZnVsbHkgcmFu IGFuZCBub24gaW5oZXJpdCB3YXMgcmVtb3ZlZC4NCg0KdGVzdD0jIFxkdQ0KICAgICAgICAgICAg ICAgICAgICAgICAgICAgICBMaXN0IG9mIHJvbGVzDQogUm9sZSBuYW1lIHwgICAgICAgICAgICAg ICAgICAgICAgICAgQXR0cmlidXRlcw0KLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogdDEgICAgICAgIHwNCiB0 ZXN0ICAgICAgfCBTdXBlcnVzZXIsIENyZWF0ZSByb2xlLCBDcmVhdGUgREIsIFJlcGxpY2F0aW9u LCBCeXBhc3MgUkxTDQoNCg0KdGVzdD0jIHNlbGVjdCByb2xuYW1lIGZyb20gcGdfdXNlciBqb2lu IHBnX2F1dGhfbWVtYmVycyBvbgoocGdfdXNlci51c2VzeXNpZD1wZ19hdXRoX21lbWJlcnMubWVt YmVyKSBqb2luIHBnX3JvbGVzIG9uCihwZ19yb2xlcy5vaWQ9cGdfYXV0aF9tZW1iZXJzLnJvbGVp ZCkgd2hlcmUgcGdfdXNlci51c2VuYW1lPSd0MSc7DQogcm9sbmFtZQ0KLS0tLS0tLS0tDQogdGVz dA0KDQpTbyBhcyB5b3UgY2FuIG5vdGljZSBub3cgJ3QxJyBoYXMgaW5oZXJpdCBhY2Nlc3MgYW5k IGl0IGlzIGFscmVhZHkgYSBtZW1iZXIKb2YgJ3Rlc3QnIHJvbGUuDQpFdmVuIGlmIEkgdHJ5IHRv IGdyYW50IGNvbW1hbmQgYWdhaW4gSSBnZXQgdGhpcyB3YXJuaW5nOg0KDQp0ZXN0PSMgZ3JhbnQg dGVzdCB0byB0MTsNCk5PVElDRTogIHJvbGUgInQxIiBoYXMgYWxyZWFkeSBiZWVuIGdyYW50ZWQg bWVtYmVyc2hpcCBpbiByb2xlICJ0ZXN0IiBieQpyb2xlICJ0ZXN0Ig0KR1JBTlQgUk9MRQ0KDQpU aGF0IG1lYW5zIG5vdyAndDEnIHVzZXIgaGFzIGFsbCB0aGUgcGVybWlzc2lvbiB0aGUgJ3Rlc3Qn IHVzZXIgaGFzLg0KDQpidXQgc3RpbGwgd2hlbiBsb2dnZWQgaW4gd2l0aCAndDEnIHVzZXIgYW5k IHRyaWVzIHRvIGNyZWF0ZSB0YWJsZSBpbiBzYW1lCmRhdGFiYXNlLg0KSSBnb3QgdGhpcyBlcnJv cjogDQp0ZXN0PT4gY3JlYXRlIHRhYmxlIHQxIChpZCBpbnQpOw0KRVJST1I6ICBwZXJtaXNzaW9u IGRlbmllZCBmb3Igc2NoZW1hIHB1YmxpYy4NCg0KU28gdG8gcmVzb2x2ZSB0aGlzIEkgZm91bmQg MiBzb2x1dGlvbnMgOg0KMS4gZGVsZXRlIHRoZSB1c2VyIGFuZCBjcmVhdGUgYSBuZXcgdXNlciB3 aXRoIHRoZSBpbmhlcml0IG9wdGlvbiBhbmQgdGhlbgpncmFudCBhbGwgcHJpdmlsZWdlcy4NCjIu IHByb3ZpZGUgaW5oZXJpdCBwcml2aWxlZ2UgdG8gICd0MScgdXNlci4gdGhlbiByZXZva2UgdGhl ICd0ZXN0JyByb2xlIGZyb20KJ3QxJyBhbmQgYXNzaWduIGl0IGFnYWluLg0KDQpCdXQgSWRlYWxs eSwgSXQgc2hvdWxkIGJlIGFibGUgdG8gdXNlIHRoZSByb2xlIHdoaWNoIGlzIGFscmVhZHkgYXNz aWduZWQgdG8KaXQgYWZ0ZXIgZ2l2aW5nIGluaGVyaXQgYWNjZXNzLg0KSW5zdGVhZCBvZiBleHBs aWNpdGx5IHJlbW92aW5nIGFuZCBhZGRpbmcgdGhlIHNhbWUgcm9sZXMgYWdhaW4uCgo= --===============8927950658377631588==--