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 1kzIHV-0006cu-DL for pgadmin-hackers@arkaria.postgresql.org; Tue, 12 Jan 2021 11:56:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kzIHU-0007W6-BX for pgadmin-hackers@arkaria.postgresql.org; Tue, 12 Jan 2021 11:56:12 +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 1kzIHU-0007Vw-0e for pgadmin-hackers@lists.postgresql.org; Tue, 12 Jan 2021 11:56:12 +0000 Received: from mail-yb1-xb2c.google.com ([2607:f8b0:4864:20::b2c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kzIHQ-000350-Lz for pgadmin-hackers@postgresql.org; Tue, 12 Jan 2021 11:56:11 +0000 Received: by mail-yb1-xb2c.google.com with SMTP id y128so1887514ybf.10 for ; Tue, 12 Jan 2021 03:56:08 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=86Kvep8xO+XzDsjDJpSa2jPcxit9o3j1tx5DCjmS4+o=; b=pEpKLAfNVh4vI0nr9pkmioPXr0kAmtZGKxUd+YOKmVcEuUYOd3xhOxB8OI6wqkUBrS p61C2hH672WsFAD95+QWiBdA71mg294lLG5ud9dmJ8aOmnHOrSnTFP1r06Twq3x+BN+0 AOyUJutwX20oW6zo+ShWGb8dMvRwiSe8pfGVbyzV5R5pY61RaayfZIEEov0Oz9An5Y3S kCUbgKglL8R401nwz0V7CvY56lGZnt7NK34W7i1nyRNnJqhhCtz1a3s587MQs/GJCb8B 0Y0aFKIS7Skh8IbpyWY8EQsZujYY4yPr61iXuG1nC+BCh+tZnP8lkvJHkJ/dbhLF+vTi NZDQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=86Kvep8xO+XzDsjDJpSa2jPcxit9o3j1tx5DCjmS4+o=; b=XkY8XG3Q01FOWZjJvdUhgC7ZZVJ5Nfgdvb8ZTYx8eIu+MYjN0C0vw+uCEOjRtE/IzG qOvw3+Pe/13Q0ETgubcFYWDYh0aLYkVN4ebjAAEwhXn9FyYKjZmF+fVCB0BK2hiDFpRE lNyCYn7NCH+gULIosnFhHj4s39ursToDgAwd7J7M35ED3akHhpGL6XD3iEei+RoxgYGm sxY0B/f5sgruYJC/wQn8HeOsQBsiWP8s9FsMdBX1Ru8cBKzcjhdIWZ6sQsAzyouky6Wn jzGWHvQ+V7UnN8VoDF3GR1MYEyI8VoPfOVjR8KnYLk/0Ngaxn0owyhsUBAYtx+YN99s0 mGcg== X-Gm-Message-State: AOAM530h/J3zAAgasx80DslU6wX2TKBSbDzqHNdEH7V3qGMA1gaGBpF9 dlq6EPgBYoH0+auv+L4dbf3VYGwMx8wLucsKL96CskJiDlwVVS4AUIham4/1XKoYG/KhXEWb0r9 5MHdanqw06JOwIT2alxOsov950FTVw1/VSYA92PQaY6z22sqfqB6YOqkoktKBrm9bWFQr8nb6VK 7M1JUM/3+2UWZ4P/ecJ9WYDA7XkYAYsmGXvtnN2Et2i5sPrhE6GdQ97qzwfQ3JpNoi3dzh X-Google-Smtp-Source: ABdhPJwbZEJfllMLQFVs8ZCyycm05q6tkVz3MgtjEcROxCD+nkjH1diKALLgaDAdn+sN1bzApl6pVFScHGO2CsQHYwg= X-Received: by 2002:a25:d805:: with SMTP id p5mr6152282ybg.46.1610452566482; Tue, 12 Jan 2021 03:56:06 -0800 (PST) MIME-Version: 1.0 From: Nikhil Mohite Date: Tue, 12 Jan 2021 17:25:55 +0530 Message-ID: Subject: [pgAdmin][RM-6075]: Non-admin user is unable to view shared server created using 'Service'. To: pgadmin-hackers Content-Type: multipart/mixed; boundary="00000000000027df2b05b8b2b5fd" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --00000000000027df2b05b8b2b5fd Content-Type: multipart/alternative; boundary="00000000000027df2905b8b2b5fb" --00000000000027df2905b8b2b5fb Content-Type: text/plain; charset="UTF-8" Hi Team, Please find the attached patch for RM-6075: Non-admin user is unable to view shared server created using 'Service'. 1. Added migration to remove "Not null" constraints from a port column of sharedserver table. 2. Updated model class of sharedserver table for the same. -- *Thanks & Regards,* *Nikhil Mohite* *Software Engineer.* *EDB Postgres* *Mob.No: +91-7798364578.* --00000000000027df2905b8b2b5fb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Team,


1. Added migration to remove "No= t null" constraints from a port column of sharedserver=C2=A0table. --00000000000027df2905b8b2b5fb-- --00000000000027df2b05b8b2b5fd Content-Type: application/octet-stream; name="RM_6075.patch" Content-Disposition: attachment; filename="RM_6075.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kjtxsu5y0 ZGlmZiAtLWdpdCBhL3dlYi9taWdyYXRpb25zL3ZlcnNpb25zL2EzOWJkMDE1YjY0NF8ucHkgYi93 ZWIvbWlncmF0aW9ucy92ZXJzaW9ucy9hMzliZDAxNWI2NDRfLnB5Cm5ldyBmaWxlIG1vZGUgMTAw NjQ0CmluZGV4IDAwMDAwMDAwLi5kYTg4N2FiMgotLS0gL2Rldi9udWxsCisrKyBiL3dlYi9taWdy YXRpb25zL3ZlcnNpb25zL2EzOWJkMDE1YjY0NF8ucHkKQEAgLTAsMCArMSw5NyBAQAorCisiIiJl bXB0eSBtZXNzYWdlCisKK1JldmlzaW9uIElEOiBhMzliZDAxNWI2NDQKK1JldmlzZXM6IDgxYzdm ZmVmZmVlZQorQ3JlYXRlIERhdGU6IDIwMjEtMDEtMTIgMTU6NDY6NDkuMjgzMDIxCisKKyIiIgor ZnJvbSBwZ2FkbWluLm1vZGVsIGltcG9ydCBkYgorCisKKyMgcmV2aXNpb24gaWRlbnRpZmllcnMs IHVzZWQgYnkgQWxlbWJpYy4KK3JldmlzaW9uID0gJ2EzOWJkMDE1YjY0NCcKK2Rvd25fcmV2aXNp b24gPSAnODFjN2ZmZWZmZWVlJworYnJhbmNoX2xhYmVscyA9IE5vbmUKK2RlcGVuZHNfb24gPSBO b25lCisKKworZGVmIHVwZ3JhZGUoKToKKyAgICAjIFJlbmFtZSBvbGRlciB0YWJsZSB0byBzYXZl IHByZXZpb3VzIGRhdGEKKyAgICBkYi5lbmdpbmUuZXhlY3V0ZSgiQUxURVIgVEFCTEUgc2hhcmVk c2VydmVyIFJFTkFNRSBUTyBzaGFyZWRzZXJ2ZXJfb2xkIikKKworICAgICMgQ3JlYXRlIG5ldyB0 YWJsZSB3aXRoIHJlbW92ZWQgbm90IG51bGwgY29uc3RyYWludHMgZm9yIHBvcnQgY29sdW1uLgor ICAgIGRiLmVuZ2luZS5leGVjdXRlKCIiIgorICAgICAgICBDUkVBVEUgVEFCTEUgc2hhcmVkc2Vy dmVyICgKKyAgICAgICAgaWQJSU5URUdFUiBOT1QgTlVMTCwKKyAgICAgICAgdXNlcl9pZAlJTlRF R0VSIE5PVCBOVUxMLAorICAgICAgICBzZXJ2ZXJfb3duZXIgVkFSQ0hBUig2NCksCisgICAgICAg IHNlcnZlcmdyb3VwX2lkCUlOVEVHRVIgTk9UIE5VTEwsCisgICAgICAgIG5hbWUJVkFSQ0hBUigx MjgpIE5PVCBOVUxMLAorICAgICAgICBob3N0CVZBUkNIQVIoMTI4KSwKKyAgICAgICAgcG9ydAlJ TlRFR0VSLAorICAgICAgICBtYWludGVuYW5jZV9kYglWQVJDSEFSKDY0KSwKKyAgICAgICAgdXNl cm5hbWUJVkFSQ0hBUig2NCksCisgICAgICAgIHBhc3N3b3JkCVZBUkNIQVIoNjQpLAorICAgICAg ICByb2xlCVZBUkNIQVIoNjQpLAorICAgICAgICBzc2xfbW9kZQlWQVJDSEFSKDE2KSBOT1QgTlVM TCBDSEVDSyhzc2xfbW9kZSBJTgorICAgICAgICAgICAgKCAnYWxsb3cnICwgJ3ByZWZlcicgLCAn cmVxdWlyZScgLCAnZGlzYWJsZScgLAorICAgICAgICAgICAgICAndmVyaWZ5LWNhJyAsICd2ZXJp ZnktZnVsbCcgKQorICAgICAgICApLAorICAgICAgICBjb21tZW50CVZBUkNIQVIoMTAyNCksCisg ICAgICAgIGRpc2NvdmVyeV9pZAlWQVJDSEFSKDEyOCksCisgICAgICAgIGhvc3RhZGRyCVRFWFQo MTAyNCksCisgICAgICAgIGRiX3JlcwlURVhULAorICAgICAgICBwYXNzZmlsZQlURVhULAorICAg ICAgICBzc2xjZXJ0CVRFWFQsCisgICAgICAgIHNzbGtleQlURVhULAorICAgICAgICBzc2xyb290 Y2VydAlURVhULAorICAgICAgICBzc2xjcmwJVEVYVCwKKyAgICAgICAgc3NsY29tcHJlc3Npb24J SU5URUdFUiBERUZBVUxUIDAsCisgICAgICAgIGJnY29sb3IgVEVYVCgxMCksCisgICAgICAgIGZn Y29sb3IgVEVYVCgxMCksCisgICAgICAgIHNlcnZpY2UgVEVYVCwKKyAgICAgICAgdXNlX3NzaF90 dW5uZWwgSU5URUdFUiBERUZBVUxUIDAsCisgICAgICAgIHR1bm5lbF9ob3N0IFRFWFQsCisgICAg ICAgIHR1bm5lbF9wb3J0IFRFWFQsCisgICAgICAgIHR1bm5lbF91c2VybmFtZSBURVhULAorICAg ICAgICB0dW5uZWxfYXV0aGVudGljYXRpb24gSU5URUdFUiBERUZBVUxUIDAsCisgICAgICAgIHR1 bm5lbF9pZGVudGl0eV9maWxlIFRFWFQsCisgICAgICAgIHNoYXJlZCBCT09MRUFOIE5PVCBOVUxM LAorICAgICAgICBzYXZlX3Bhc3N3b3JkIEJPT0xFQU4gTk9UIE5VTEwsCisgICAgICAgIHR1bm5l bF9wYXNzd29yZCBWQVJDSEFSKDY0KSwKKyAgICAgICAgY29ubmVjdF90aW1lb3V0IElOVEVHRVIg LAorICAgICAgICBQUklNQVJZIEtFWShpZCksCisgICAgICAgIEZPUkVJR04gS0VZKHVzZXJfaWQp IFJFRkVSRU5DRVMgdXNlcihpZCksCisgICAgICAgIEZPUkVJR04gS0VZKHNlcnZlcmdyb3VwX2lk KSBSRUZFUkVOQ0VTIHNlcnZlcmdyb3VwKGlkKQorICAgICAgICApOworICAgICIiIikKKworICAg ICMgQ29weSBvbGQgZGF0YSBhZ2FpbiBpbnRvIHRhYmxlLgorICAgIGRiLmVuZ2luZS5leGVjdXRl KCIiIgorICAgICAgICBJTlNFUlQgSU5UTyBzaGFyZWRzZXJ2ZXIgKAorICAgICAgICAgICAgaWQs IHVzZXJfaWQsIHNlcnZlcl9vd25lciwgc2VydmVyZ3JvdXBfaWQsIG5hbWUsIGhvc3QsIHBvcnQs CisgICAgICAgICAgICBtYWludGVuYW5jZV9kYiwgdXNlcm5hbWUsIHBhc3N3b3JkLCByb2xlLCBz c2xfbW9kZSwgY29tbWVudCwKKyAgICAgICAgICAgIGRpc2NvdmVyeV9pZCwgaG9zdGFkZHIsIGRi X3JlcywgcGFzc2ZpbGUsIHNzbGNlcnQsIHNzbGtleSwKKyAgICAgICAgICAgIHNzbHJvb3RjZXJ0 LCBzc2xjcmwsIHNzbGNvbXByZXNzaW9uLCBiZ2NvbG9yLCBmZ2NvbG9yLCBzZXJ2aWNlLAorICAg ICAgICAgICAgdXNlX3NzaF90dW5uZWwsIHR1bm5lbF9ob3N0LCB0dW5uZWxfcG9ydCwgdHVubmVs X3VzZXJuYW1lLAorICAgICAgICAgICAgdHVubmVsX2F1dGhlbnRpY2F0aW9uLCB0dW5uZWxfaWRl bnRpdHlfZmlsZSwgc2hhcmVkLCBzYXZlX3Bhc3N3b3JkLAorICAgICAgICAgICAgdHVubmVsX3Bh c3N3b3JkLCBjb25uZWN0X3RpbWVvdXQKKworICAgICAgICApIFNFTEVDVAorICAgICAgICAgICAg aWQsIHVzZXJfaWQsIHNlcnZlcl9vd25lciwgc2VydmVyZ3JvdXBfaWQsIG5hbWUsIGhvc3QsIHBv cnQsCisgICAgICAgICAgICBtYWludGVuYW5jZV9kYiwgdXNlcm5hbWUsIHBhc3N3b3JkLCByb2xl LCBzc2xfbW9kZSwgY29tbWVudCwKKyAgICAgICAgICAgIGRpc2NvdmVyeV9pZCwgaG9zdGFkZHIs IGRiX3JlcywgcGFzc2ZpbGUsIHNzbGNlcnQsIHNzbGtleSwKKyAgICAgICAgICAgIHNzbHJvb3Rj ZXJ0LCBzc2xjcmwsIHNzbGNvbXByZXNzaW9uLCBiZ2NvbG9yLCBmZ2NvbG9yLCBzZXJ2aWNlLAor ICAgICAgICAgICAgdXNlX3NzaF90dW5uZWwsIHR1bm5lbF9ob3N0LCB0dW5uZWxfcG9ydCwgdHVu bmVsX3VzZXJuYW1lLAorICAgICAgICAgICAgdHVubmVsX2F1dGhlbnRpY2F0aW9uLCB0dW5uZWxf aWRlbnRpdHlfZmlsZSwgc2hhcmVkLCBzYXZlX3Bhc3N3b3JkLAorICAgICAgICAgICAgdHVubmVs X3Bhc3N3b3JkLCBjb25uZWN0X3RpbWVvdXQKKyAgICAgICAgRlJPTSBzaGFyZWRzZXJ2ZXJfb2xk IiIiKQorCisgICAgIyBEcm9wIG9sZGVyIHRhYmxlLgorICAgIGRiLmVuZ2luZS5leGVjdXRlKCJE Uk9QIFRBQkxFIHNoYXJlZHNlcnZlcl9vbGQiKQorCisKK2RlZiBkb3duZ3JhZGUoKToKKyAgICAj IHBnQWRtaW4gb25seSB1cGdyYWRlcywgZG93bmdyYWRlIG5vdCBpbXBsZW1lbnRlZC4KKyAgICBw YXNzCmRpZmYgLS1naXQgYS93ZWIvcGdhZG1pbi9tb2RlbC9fX2luaXRfXy5weSBiL3dlYi9wZ2Fk bWluL21vZGVsL19faW5pdF9fLnB5CmluZGV4IDM0MTM2ZDYzLi5kMWY0OTgxOCAxMDA2NDQKLS0t IGEvd2ViL3BnYWRtaW4vbW9kZWwvX19pbml0X18ucHkKKysrIGIvd2ViL3BnYWRtaW4vbW9kZWwv X19pbml0X18ucHkKQEAgLTM3OSw4ICszNzksNyBAQCBjbGFzcyBTaGFyZWRTZXJ2ZXIoZGIuTW9k ZWwpOgogICAgIGhvc3RhZGRyID0gZGIuQ29sdW1uKGRiLlN0cmluZygxMjgpLCBudWxsYWJsZT1U cnVlKQogICAgIHBvcnQgPSBkYi5Db2x1bW4oCiAgICAgICAgIGRiLkludGVnZXIoKSwKLSAgICAg ICAgZGIuQ2hlY2tDb25zdHJhaW50KCdwb3J0ID49IDEgQU5EIHBvcnQgPD0gNjU1MzQnKSwKLSAg ICAgICAgbnVsbGFibGU9RmFsc2UpCisgICAgICAgIG51bGxhYmxlPVRydWUpCiAgICAgbWFpbnRl bmFuY2VfZGIgPSBkYi5Db2x1bW4oZGIuU3RyaW5nKDY0KSwgbnVsbGFibGU9VHJ1ZSkKICAgICB1 c2VybmFtZSA9IGRiLkNvbHVtbihkYi5TdHJpbmcoNjQpLCBudWxsYWJsZT1GYWxzZSkKICAgICBw YXNzd29yZCA9IGRiLkNvbHVtbihkYi5TdHJpbmcoNjQpLCBudWxsYWJsZT1UcnVlKQo= --00000000000027df2b05b8b2b5fd--