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 1oQrIK-00027z-8a for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Aug 2022 14:23:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oQrII-0000Fq-TF for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Aug 2022 14:23:46 +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 1oQrII-0000FX-1x for pgsql-hackers@lists.postgresql.org; Wed, 24 Aug 2022 14:23:46 +0000 Received: from mail-pj1-x1030.google.com ([2607:f8b0:4864:20::1030]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oQrIF-00014v-CC for pgsql-hackers@postgresql.org; Wed, 24 Aug 2022 14:23:45 +0000 Received: by mail-pj1-x1030.google.com with SMTP id m10-20020a17090a730a00b001fa986fd8eeso1804043pjk.0 for ; Wed, 24 Aug 2022 07:23:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=content-language:content-transfer-encoding:in-reply-to:mime-version :user-agent:date:message-id:from:references:cc:to:subject:from:to:cc; bh=iktwhbg06ZwO8ymfcX/Bw00POKVm0+bfQ2FDso6wA74=; b=SGpMMoJf89GYaQ6hB/EqT5gcVXY4h7magAxM4Yy9G86QkoUaXcHL5PUXYlJPmDY8X4 rHlbWzuRYRO3ro317RtSbvCerfSnjI95QuloGt/vgxaanIbXd61WJPLi73tshSTUVYIv AShCjjvJhINU42vAvFyaT+UMLSkfIGq5v/h91quNLjTKCzw9XUwG3YIdEO1n1Si5QfrP h1nFr7tH7GKgHGFAPgznyQYlgDDTEf4BRr7bdZXWApMLzZrYukOb9DLyVAS+MlGCU5dx pPpSWVSTv4zhuH4lRq2K+b1e7IBWbWOfoztTK8u7hqUJojBeDYImkI0efMCafkW3kWD0 JJdw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-language:content-transfer-encoding:in-reply-to:mime-version :user-agent:date:message-id:from:references:cc:to:subject :x-gm-message-state:from:to:cc; bh=iktwhbg06ZwO8ymfcX/Bw00POKVm0+bfQ2FDso6wA74=; b=MTBubiFlt5Ms4ufa79mpDbIM6A7zj5l21ZNHmGqlVt1uiq8zDeqwaSNeU3Shr5HCdf MmwA9NacnYZ3QLcqW3fEWN7vSF6CyyjUxM64kHtnuhblVr95HQaB7KHbfQuAKsVRCdMm xailBonw0p4YAefWqP7N2TexVe1j2Nns88UiTLlB/HJBg5BhIi0nDXTPpS79eI0ybmbk gnoSHblCfKsF0ctXNOjxnj690XhtSHYib2n489JxUjooNcsXWF2t0Xxsn1jhq0FlFWxv FfI/VKW8ikSDDf/P9I5wZG4Ebo51GnySwIEjMzC1zhXdy19A3H3p7wHufiGPXWub8sOX 78jg== X-Gm-Message-State: ACgBeo3cQJTJmuBmbsxJg84GB1v6gg9ULxazAyp+KuR8AAh21t2N7Q+j 3zDPEDxHZGeEQOmsDF/VABJMyCW78cVByasTPRhXFb7PZofGHnFxG3iP1DQSC0OcgQAkyTLQQ+1 0JriHIjaqhCpX4wei9SEsaM9Bc0bywkzBZPFcl1nvLqFs846DRVN9ZPKesh1T3VXPF6QX6gHIwl LMCkdW+AKnv5djNrVs0K2UdWTu32NYcqU1VWTkvEsxoFoEp7mlmE7I18uHRhBnLFGj7Zx3L4qHo k3TLwa8/Lxi1O8W1/nMgSqM4ynv8w1T0Iibgw== X-Google-Smtp-Source: AA6agR5SoHGXhonNCbisUDLhr0VxX6GknBgBOiGOSfSxj9B2Sog989pOlsDLeuU/pgn9CYoPtqmu+g== X-Received: by 2002:a17:902:d4c4:b0:172:f328:e474 with SMTP id o4-20020a170902d4c400b00172f328e474mr11548579plg.144.1661351021453; Wed, 24 Aug 2022 07:23:41 -0700 (PDT) Received: from localhost.localdomain ([45.113.251.168]) by smtp.gmail.com with ESMTPSA id c15-20020a170903234f00b00172897952a0sm12716083plh.283.2022.08.24.07.23.37 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 24 Aug 2022 07:23:40 -0700 (PDT) Subject: Re: replacing role-level NOINHERIT with a grant-level option To: Robert Haas Cc: Nathan Bossart , Joe Conway , Tom Lane , "Bossart, Nathan" , Stephen Frost , PostgreSQL-development References: <20220701025830.GA369935@nathanxps13> <20220701211225.GA418166@nathanxps13> <20220702221635.GB1044460@nathanxps13> <20220703171742.GB1048244@nathanxps13> <8210e573-c861-fe45-302b-56d7352aae48@enterprisedb.com> <030c1dbf-5a8e-706d-698c-b1cdfcb6ce0f@enterprisedb.com> From: tushar Message-ID: Date: Wed, 24 Aug 2022 19:53:36 +0530 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.14.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US 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 On 8/24/22 12:28 AM, Robert Haas wrote: > This patch needed to be rebased pretty extensively after commit > ce6b672e4455820a0348214be0da1a024c3f619f. Here is a new version. Thanks, Robert, I have retested this patch with my previous scenarios and things look good to me. -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company