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 1lEVBT-00051e-UJ for pgadmin-hackers@arkaria.postgresql.org; Tue, 23 Feb 2021 10:44:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lEVBN-00083K-Th for pgadmin-hackers@arkaria.postgresql.org; Tue, 23 Feb 2021 10:44:45 +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 1lEVBN-00083C-In for pgadmin-hackers@lists.postgresql.org; Tue, 23 Feb 2021 10:44:45 +0000 Received: from mail-yb1-xb2e.google.com ([2607:f8b0:4864:20::b2e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lEVBC-0003pt-LH for pgadmin-hackers@postgresql.org; Tue, 23 Feb 2021 10:44:41 +0000 Received: by mail-yb1-xb2e.google.com with SMTP id m9so15984532ybk.8 for ; Tue, 23 Feb 2021 02:44:34 -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=bcPGFwUc54FyXN26vG1F7ECPIy3JGs9c54KjwlSEK80=; b=Ridfi0L7kj6IGlH59gZaWoxxYv7JFaaqgO0/CixKkEQapSdpiWSd1OMjVgC0GupmQS 7U9PGCXjofXcydExcCMHZFjo7sw0Fu4WFO9pYvJU0aanRidY/SFQvapy2QoZnwfDwtKX nXQFaFMX+koCa7l3kjlKXCo1aIwfw0kOt5c4V9IXrKL2D7B0INGAM68SVmDOF2moJ4jF l6nX0CY3C0G0N1bmXHxe0hkLP1eqP6CC0fQlvE2/y+CDhVpVrbF8GTEJFsiqUgGBBeq7 Ce9ad6yqnPGX6ad8WkGR8rhyyAO2/WVZUZhiGI/Y9tuXMLkhQMI8lqhYwlG0goAyH/oI YcUQ== 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=bcPGFwUc54FyXN26vG1F7ECPIy3JGs9c54KjwlSEK80=; b=RY71xBGYI2u32yySm0mTQ1QLoToosfZjhoqOylL/QY8Ck4d6uwfE9oQupFTzsr7Nmb z5xyNG5U6PwKWYf4oADpQL9l/t9tzW+sfkVXTOtaJVS6pELdA1RplqvpCswMUfmTsHIV NkYdj4A0PZPO4l4f2fNvZqYfTYEn+PyP5237dvXtFtlkbDwwh2QL+tEfQREzTPA43RPU fqHVQ1Rpvxd5lN3PObluDrlcLvT4JZxw7z3D2rvIaMlG6XJeJOyjdPNjv8DZ+FZo0RWU wYruXddTfSOj1Thw7MmJvv+1uKF1jjXSfGr+eWxlejmovWWKlM8GJTKnvyuJtL08vcE+ m+Ow== X-Gm-Message-State: AOAM530qmSKitheZtbwf4A8b4DStVB6sG6yNoiXlH44RBDYj3FdtKlnw pI0fiat8J4Oh6LVzEBZxUXyg5XfC+O2gCAFmSkv9wzpXYYUPlX/5NkiLhY/OfopGZjYZlLFIIBR tJ+dPRlRqfYtvgDv5/UWKyTEpmjiUdw7T+r4NnOBgjpCAFLILcqAvAYzMTs3BcaakWL4RjsseRO lojeZIunnSs2nq6yxutMxrdbZpUv4Mh8GmbCaT3EdRaFRPsv6GY5xrbmKWDHWCXi30wbOo X-Google-Smtp-Source: ABdhPJxzB/w+FOD5nxelByy8stzm1YZZ/erO1HSpvHTLnHXPFmhfZFGx20dk0jUqGN/1G/HJBfpSTWpDEvyV3jCS9pM= X-Received: by 2002:a25:c586:: with SMTP id v128mr2310683ybe.416.1614077071869; Tue, 23 Feb 2021 02:44:31 -0800 (PST) MIME-Version: 1.0 From: Nikhil Mohite Date: Tue, 23 Feb 2021 16:14:20 +0530 Message-ID: Subject: [pgAdmin][RM-6159]: Even though a user have the role pg_signal_backend isn't possible to kill the session via the GUI (Dashboard Tab). To: pgadmin-hackers Content-Type: multipart/mixed; boundary="00000000000082961a05bbfe9abd" 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 --00000000000082961a05bbfe9abd Content-Type: multipart/alternative; boundary="00000000000082961405bbfe9abb" --00000000000082961405bbfe9abb Content-Type: text/plain; charset="UTF-8" Hi Team, Please find the attached patch for RM-6159 : Even though a user have the role pg_signal_backend isn't possible to kill the session via the GUI (Dashboard Tab). -- *Thanks & Regards,* *Nikhil Mohite* *Software Engineer.* *EDB Postgres* *Mob.No: +91-7798364578.* --00000000000082961405bbfe9abb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Team,

Please find the attached patch= for RM-6159:=C2= =A0Even though a user have the role pg_signal_backend isn't possible to= kill the session via the GUI (Dashboard Tab).


--
= Software Engineer.
Mob.No: +91= -7798364578.
--00000000000082961405bbfe9abb-- --00000000000082961a05bbfe9abd Content-Type: application/octet-stream; name="RM_6159.patch" Content-Disposition: attachment; filename="RM_6159.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_klhvkxod0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL2Rhc2hib2FyZC9zdGF0aWMvanMvZGFzaGJvYXJkLmpz IGIvd2ViL3BnYWRtaW4vZGFzaGJvYXJkL3N0YXRpYy9qcy9kYXNoYm9hcmQuanMKaW5kZXggZDhj Mjk4MjAuLjFjY2U5NTZmIDEwMDY0NAotLS0gYS93ZWIvcGdhZG1pbi9kYXNoYm9hcmQvc3RhdGlj L2pzL2Rhc2hib2FyZC5qcworKysgYi93ZWIvcGdhZG1pbi9kYXNoYm9hcmQvc3RhdGljL2pzL2Rh c2hib2FyZC5qcwpAQCAtMzAsNyArMzAsOCBAQCBkZWZpbmUoJ3BnYWRtaW4uZGFzaGJvYXJkJywg WwogICAgIGlzX3N1cGVyX3VzZXIgPSBmYWxzZSwKICAgICBjdXJyZW50X3VzZXIsIG1haW50ZW5h bmNlX2RhdGFiYXNlLAogICAgIGlzX3NlcnZlcl9kYXNoYm9hcmQgPSBmYWxzZSwKLSAgICBpc19k YXRhYmFzZV9kYXNoYm9hcmQgPSBmYWxzZTsKKyAgICBpc19kYXRhYmFzZV9kYXNoYm9hcmQgPSBm YWxzZSwKKyAgICBjYW5fc2lnbmFsX2JhY2tlbmQgPSBmYWxzZTsKIAogICAvLyBDdXN0b20gQmFj a0dyaWQgY2VsbCwgUmVzcG9uc2libGUgZm9yIGNhbmNlbGxpbmcgYWN0aXZlIHNlc3Npb25zCiAg IHZhciBjdXN0b21EYXNoYm9hcmRBY3Rpb25DZWxsID0gQmFja2dyaWQuRXh0ZW5zaW9uLkRlbGV0 ZUNlbGwuZXh0ZW5kKHsKQEAgLTI5Myw2ICsyOTQsNyBAQCBkZWZpbmUoJ3BnYWRtaW4uZGFzaGJv YXJkJywgWwogICAgICAgICAgIC8vIENoZWNrIGlmIHVzZXIgaXMgc3VwZXIgdXNlcgogICAgICAg ICAgIHZhciBzZXJ2ZXIgPSB0cmVlSGllcmFyY2h5WydzZXJ2ZXInXTsKICAgICAgICAgICBtYWlu dGVuYW5jZV9kYXRhYmFzZSA9IChzZXJ2ZXIgJiYgc2VydmVyLmRiKSB8fCBudWxsOworICAgICAg ICAgIGNhbl9zaWduYWxfYmFja2VuZCA9IHNlcnZlci51c2VyLmNhbl9zaWduYWxfYmFja2VuZDsK IAogICAgICAgICAgIGlmIChzZXJ2ZXIgJiYgc2VydmVyLnVzZXIgJiYgc2VydmVyLnVzZXIuaXNf c3VwZXJ1c2VyKSB7CiAgICAgICAgICAgICBpc19zdXBlcl91c2VyID0gdHJ1ZTsKQEAgLTExNDks NiArMTE1MSw5IEBAIGRlZmluZSgncGdhZG1pbi5kYXNoYm9hcmQnLCBbCiAgICAgICAgICAgZ2V0 dGV4dCgnVGhlIHNlc3Npb24gaXMgYWxyZWFkeSBpbiBpZGxlIHN0YXRlLicpCiAgICAgICAgICk7 CiAgICAgICAgIHJldHVybiBmYWxzZTsKKyAgICAgIH0gZWxzZSBpZiAoY2FuX3NpZ25hbF9iYWNr ZW5kKSB7CisgICAgICAgIC8vIHVzZXIgd2l0aCBtZW1iZXJzaGlwIG9mICdwZ19zaWduYWxfYmFj a2VuZCcgY2FuIHRlcm1pbmF0ZSB0aGUgc2Vzc2lvbiBvZiBub24gYWRtaW4gdXNlci4KKyAgICAg ICAgcmV0dXJuIHRydWU7CiAgICAgICB9IGVsc2UgaWYgKGlzX3N1cGVyX3VzZXIpIHsKICAgICAg ICAgLy8gU3VwZXIgdXNlciBjYW4gZG8gYW55dGhpbmcKICAgICAgICAgcmV0dXJuIHRydWU7CmRp ZmYgLS1naXQgYS93ZWIvcGdhZG1pbi91dGlscy9kcml2ZXIvcHN5Y29wZzIvY29ubmVjdGlvbi5w eSBiL3dlYi9wZ2FkbWluL3V0aWxzL2RyaXZlci9wc3ljb3BnMi9jb25uZWN0aW9uLnB5CmluZGV4 IGNkNmEwN2IzLi43ZGFkYjIyYSAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vdXRpbHMvZHJpdmVy L3BzeWNvcGcyL2Nvbm5lY3Rpb24ucHkKKysrIGIvd2ViL3BnYWRtaW4vdXRpbHMvZHJpdmVyL3Bz eWNvcGcyL2Nvbm5lY3Rpb24ucHkKQEAgLTU1MiwxMiArNTUyLDIwIEBAIFdIRVJFIGRiLmRhdG5h bWUgPSBjdXJyZW50X2RhdGFiYXNlKCkiIiIpCiAgICAgICAgICIiIgogICAgICAgICBzdGF0dXMg PSBzZWxmLl9leGVjdXRlKGN1ciwgIiIiCiAgICAgICAgIFNFTEVDVAotICAgICAgICAgICAgb2lk IGFzIGlkLCByb2xuYW1lIGFzIG5hbWUsIHJvbHN1cGVyIGFzIGlzX3N1cGVydXNlciwKLSAgICAg ICAgICAgIENBU0UgV0hFTiByb2xzdXBlciBUSEVOIHRydWUgRUxTRSByb2xjcmVhdGVyb2xlIEVO RCBhcworICAgICAgICAgICAgcm9sZXMub2lkIGFzIGlkLCByb2xlcy5yb2xuYW1lIGFzIG5hbWUs CisgICAgICAgICAgICByb2xlcy5yb2xzdXBlciBhcyBpc19zdXBlcnVzZXIsCisgICAgICAgICAg ICBDQVNFIFdIRU4gcm9sZXMucm9sc3VwZXIgVEhFTiB0cnVlIEVMU0Ugcm9sZXMucm9sY3JlYXRl cm9sZSBFTkQgYXMKICAgICAgICAgICAgIGNhbl9jcmVhdGVfcm9sZSwKLSAgICAgICAgICAgIENB U0UgV0hFTiByb2xzdXBlciBUSEVOIHRydWUgRUxTRSByb2xjcmVhdGVkYiBFTkQgYXMgY2FuX2Ny ZWF0ZV9kYgorICAgICAgICAgICAgQ0FTRSBXSEVOIHJvbGVzLnJvbHN1cGVyIFRIRU4gdHJ1ZQor ICAgICAgICAgICAgRUxTRSByb2xlcy5yb2xjcmVhdGVkYiBFTkQgYXMgY2FuX2NyZWF0ZV9kYiwK KyAgICAgICAgICAgIENBU0UgV0hFTiAncGdfc2lnbmFsX2JhY2tlbmQnPUFOWShBUlJBWSgKKyAg ICAgICAgICAgICAgICBTRUxFQ1QgcGdfY2F0YWxvZy5wZ19yb2xlcy5yb2xuYW1lIEZST00KKyAg ICAgICAgICAgICAgICBwZ19jYXRhbG9nLnBnX2F1dGhfbWVtYmVycyBtIEpPSU4gcGdfY2F0YWxv Zy5wZ19yb2xlcyBPTgorICAgICAgICAgICAgICAgIChtLnJvbGVpZCA9IHBnX2NhdGFsb2cucGdf cm9sZXMub2lkKSBXSEVSRQorICAgICAgICAgICAgICAgICBtLm1lbWJlciA9IHJvbGVzLm9pZCkp IFRIRU4gVHJ1ZQorICAgICAgICAgICAgRUxTRSBGYWxzZSBFTkQgYXMgY2FuX3NpZ25hbF9iYWNr ZW5kCiAgICAgICAgIEZST00KLSAgICAgICAgICAgIHBnX2NhdGFsb2cucGdfcm9sZXMKKyAgICAg ICAgICAgIHBnX2NhdGFsb2cucGdfcm9sZXMgYXMgcm9sZXMKICAgICAgICAgV0hFUkUKICAgICAg ICAgICAgIHJvbG5hbWUgPSBjdXJyZW50X3VzZXIiIiIpCiAK --00000000000082961a05bbfe9abd--