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 1m5OUp-0002KG-0x for pgadmin-hackers@arkaria.postgresql.org; Mon, 19 Jul 2021 08:19:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m5OUm-00010j-B3 for pgadmin-hackers@arkaria.postgresql.org; Mon, 19 Jul 2021 08:19:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m5OUl-0000zj-Sw for pgadmin-hackers@lists.postgresql.org; Mon, 19 Jul 2021 08:19:24 +0000 Received: from mail-pj1-x1029.google.com ([2607:f8b0:4864:20::1029]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m5OUe-00083t-AN for pgadmin-hackers@postgresql.org; Mon, 19 Jul 2021 08:19:22 +0000 Received: by mail-pj1-x1029.google.com with SMTP id gp5-20020a17090adf05b0290175c085e7a5so6555358pjb.0 for ; Mon, 19 Jul 2021 01:19:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=DEHpQMGxT8dHLkYqwhSQp2KOsnXjX+HAM+QdAqGo230=; b=VOuKneDM0xPvZqL1n+cms6OoTtE5Ii0nlmBcGDGLmhDFQLgQys66iczaTSUTPOpS1K Kp3wyUGvLeGVvr6H4dnt/IThm49J17jnCV/irPZrgi7AvuuOeUUybUz86xeswrMTUqzv jRS9EvR7KNkeeXv1VDLOtO9shYyzM6w7oX2zifESIyLTMSc5kv6hVedUx5hsq/dotFl9 AeWnI6NSBCiKK/obMXSgaYnJaYUbzj1K0rbIMCP7ULB6yRQHKo4vXeH7Iz6pBlafBhtc PVSIq/Y5sUDzdzRt2GSpelTMScq/S5EO2MeWns71rd55iOLlicW7JeuD5Mr6xZGmPLuE 1d5Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=DEHpQMGxT8dHLkYqwhSQp2KOsnXjX+HAM+QdAqGo230=; b=M+QeZyFZ3+ZV3Z0W3DbuC0lsFZQfbMTELYSaO3zcYDyAVbLPGPweIKapjsXLGj0vOy o+Krw3rxw4dlgJy+ebTkuAsyrvfPbSlnHt7PqbWAQTDNoJun5BQhx4hY16JVFFiizqIe bTnEYi1jkKfAgcq8FJ6zJgAU6rajp3AbBfNbt283vFvVNbQDGW8hpD+1iqLlkSXxS9kJ dYbKlu2/XLsBs6npdjOYDu1XG2PLhTdBTdiXLat/HOo+IgC6SJ29qlgHW5fhAWoRf1iy bct1DoPPgNat16355tV47o+aQCIFcg5Up74/NNqQ3Lz0f8yLRcCLDhbP4CX2OypCeOlm rfJQ== X-Gm-Message-State: AOAM530QXcm9F27RGfYkcvf4wbFOc4kP5jh4nQcy8b095fsGoUXpjCqA hJHoJ+iW0go799hokvlE+ZjPE6o7b2rjUOaxrBcwYTpQzm8FDEMA9jGV99kAN8l7lsXtZ0Bkr8n 3t5iyNe6MiWLJVT2LC0A4QBKSctP9NNoE9mD7bfsk4Sz3fFSJ92E5z7EjK5Q5P/SpX+7LPNZf1B aPGX6grE568Vvfoahh0wzyxiRmc6JYpncDiscAUINo8ULR1vp4Wm0zxW2nNA== X-Google-Smtp-Source: ABdhPJyITE/bZMQIkERq1qKTE9zDx04O84ua8j32/od8mllP9Dhm4I9rQFs356jmN16hFE2g3CtDc2wtGMFqpq6R2DU= X-Received: by 2002:a17:902:f284:b029:12b:7fe2:c1c8 with SMTP id k4-20020a170902f284b029012b7fe2c1c8mr6728514plc.54.1626682754415; Mon, 19 Jul 2021 01:19:14 -0700 (PDT) MIME-Version: 1.0 References: <15B16A92-305E-4707-ABA5-E9970DF21B62@free.fr> In-Reply-To: From: Pradip Parkale Date: Mon, 19 Jul 2021 13:49:03 +0530 Message-ID: Subject: Re: [pgAdmin][RM6448]: [search object] error displayed for non superuser because of right on pg_catalog.pg_subscription To: Akshay Joshi Cc: pgadmin-hackers , Aditya Toshniwal Content-Type: multipart/mixed; boundary="000000000000bd746d05c7759792" 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: Archived-At: Precedence: bulk --000000000000bd746d05c7759792 Content-Type: multipart/alternative; boundary="000000000000bd746b05c7759790" --000000000000bd746b05c7759790 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Akshay, Please find the updated patch.I have added a more reliable solution to solve this issue. On Wed, Jun 23, 2021 at 12:52 PM Akshay Joshi wrote: > Thanks, the patch applied. > > On Tue, Jun 22, 2021 at 4:17 PM Pradip Parkale < > pradip.parkale@enterprisedb.com> wrote: > >> Hi Hackers, >> Please ignore my previous email and find the attached patch. I have fixe= d >> some review comments given by Aditya. >> >> On Tue, Jun 22, 2021 at 2:21 PM Fred wrote: >> >>> nice ! >>> thanks >>> >>> fred >>> >>> >>> Le 22 juin 2021 09:08:05 GMT+02:00, Pradip Parkale < >>> pradip.parkale@enterprisedb.com> a =C3=A9crit : >>>> >>>> Hi Hackers, >>>> >>>> Please find the attached patch for # 6448. I have added a check to >>>> ignore the subscription when the search type is 'All type' if the user >>>> doesn't have access to subscription. >>>> >>>> -- >>>> Thanks & Regards, >>>> Pradip Parkale >>>> Software Engineer | EnterpriseDB Corporation >>>> >>> >> >> -- >> Thanks & Regards, >> Pradip Parkale >> Software Engineer | EnterpriseDB Corporation >> > > > -- > *Thanks & Regards* > *Akshay Joshi* > *pgAdmin Hacker | Principal Software Architect* > *EDB Postgres * > > *Mobile: +91 976-788-8246* > --=20 Thanks & Regards, Pradip Parkale Software Engineer | EnterpriseDB Corporation --000000000000bd746b05c7759790 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Akshay,
Please find the updated patch.I have added = a more reliable solution to solve this=C2=A0issue.

On Wed, Jun 23, 202= 1 at 12:52 PM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Thanks, the patch applied.

On Tue, Jun 22, 2021 at 4:1= 7 PM Pradip Parkale <pradip.parkale@enterprisedb.com> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l= eft-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);pa= dding-left:1ex">
Hi Hackers,
Please ignore my=C2=A0= previous email and find the attached patch. I have fixed some review commen= ts given by Aditya.

On Tue, Jun 22, 2021 at 2:21 PM Fred <fred.escallier@free.fr= > wrote:
nice !
thanks

fred=


Le 22 juin 2021 09:08:05 GMT+02:00, = Pradip Parkale <pradip.parkale@enterprisedb.com> a =C3=A9crit=C2=A0:
Hi Hackers,

Please find the attached pa= tch for # 6448. I have added a check to ignore the subscription when the se= arch type is 'All type' if the user doesn't have access to subs= cription.

--
Thanks & Regards,
Pradip Parkale
Software Engineer | Enterpri= seDB Corporation


--
= Thanks & Regards,
Pradip Parka= le
Software Engineer | EnterpriseDB Corporation


--
Thank= s & Regards
Akshay Joshi
pgAdmin Hacker | Principal Softw= are Architect
EDB Po= stgres
Mobile: +91 976-788-8246



--
Thanks & Regards,
Pradip Park= ale
Software Engineer | EnterpriseDB Corporation
--000000000000bd746b05c7759790-- --000000000000bd746d05c7759792 Content-Type: application/octet-stream; name="RM6448_v2.patch" Content-Disposition: attachment; filename="RM6448_v2.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kracsvyz0 ZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWluL3Rvb2xzL3NlYXJjaF9vYmplY3RzL3V0aWxzLnB5IGIv d2ViL3BnYWRtaW4vdG9vbHMvc2VhcmNoX29iamVjdHMvdXRpbHMucHkKaW5kZXggNDA3ZGM4M2Yy Li4xNmNmZWZjZDkgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL3Rvb2xzL3NlYXJjaF9vYmplY3Rz L3V0aWxzLnB5CisrKyBiL3dlYi9wZ2FkbWluL3Rvb2xzL3NlYXJjaF9vYmplY3RzL3V0aWxzLnB5 CkBAIC05OCw4ICs5OCwxMiBAQCBjbGFzcyBTZWFyY2hPYmplY3RzSGVscGVyOgogICAgICAgICAi IiIKIAogICAgICAgICBpZiBvYmpfdHlwZSA9PSAnYWxsJzoKLSAgICAgICAgICAgIHN0YXR1cywg ZXJyb3IgPSBjb25uLmV4ZWN1dGVfZGljdCgnc2VsZWN0ICogZnJvbSBwZ19zdWJzY3JpcHRpb24n KQotICAgICAgICAgICAgaWYgJ3Blcm1pc3Npb24gZGVuaWVkJyBpbiBlcnJvcjoKKyAgICAgICAg ICAgIHN0YXR1cywgZXJyb3IgPSBjb25uLmV4ZWN1dGVfZGljdCgKKyAgICAgICAgICAgICAgICAi U0VMRUNUIENPVU5UKDEpIEZST00gaW5mb3JtYXRpb25fc2NoZW1hLnRhYmxlX3ByaXZpbGVnZXMg ICIKKyAgICAgICAgICAgICAgICAiV0hFUkUgdGFibGVfbmFtZSA9ICdwZ19zdWJzY3JpcHRpb24n ICIKKyAgICAgICAgICAgICAgICAiQU5EIHByaXZpbGVnZV90eXBlID0gJ1NFTEVDVCciKQorICAg ICAgICAgICAgaWYgJ2NvdW50JyBpbiBlcnJvclsncm93cyddWzBdIGFuZCBcCisgICAgICAgICAg ICAgICAgICAgIGVycm9yWydyb3dzJ11bMF1bJ2NvdW50J10gPT0gJzAnOgogICAgICAgICAgICAg ICAgIHNraXBfb2JqX3R5cGUuYXBwZW5kKCdzdWJzY3JpcHRpb24nKQogCiAgICAgICAgIHJldHVy biBza2lwX29ial90eXBlCg== --000000000000bd746d05c7759792--