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 1oBAwc-00073B-Av for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Jul 2022 08:08:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oBAwb-0006Zs-7S for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Jul 2022 08:08:33 +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 1oBAwa-0006Yg-CU for pgsql-hackers@lists.postgresql.org; Tue, 12 Jul 2022 08:08:32 +0000 Received: from mail-pg1-x533.google.com ([2607:f8b0:4864:20::533]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oBAwX-0007oT-6A for pgsql-hackers@postgresql.org; Tue, 12 Jul 2022 08:08:31 +0000 Received: by mail-pg1-x533.google.com with SMTP id bh13so6903170pgb.4 for ; Tue, 12 Jul 2022 01:08:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=hyHuKjrR5SvlVn3hFuFgeTHitXNiV3SMmUfEhlUGnXI=; b=A6W8RD4kmBTNNH7IC9g+/1uGNHXU0MlKT74rx4ovOLczs29JpvV4ymOs2oASef14Jd v6B2I8UCsSgglw5EoH36GvZ5OI8QiFLDw6zYLKttZUw1nmW5iyYXny4wrhWK4b5snmVU 8i6Jh8FG4lX3lcp8vpq+1yhH/5l+SEOLkQ2rvlZWD1AsRx9qPsYAfIP21e8/Pyor1rJc rdxFnwsGwC4XkPeJPP18724dW8P7gqepvxcqnYvtCwn8rRGja4FZ7A2melAZwAa/Gt0K zkHpgZVPGYo3QZV3/YKrMxTvWbaX0aG13NID13y6YbvneIapuKjH/JubM3c4es5Otbrg /3bw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=hyHuKjrR5SvlVn3hFuFgeTHitXNiV3SMmUfEhlUGnXI=; b=1JYw8aj0aKdCtYr+TQJrBE/qH9c87TdvXapRwP52mEgNtXFnaMXgUVh+GOqraqiznE TbPJcC6qQZ1b4z1+ya/h0zRk/Mwvw2xd0RckXpq7qPTl+P4NzW0cT//X8IUrqOadtRKk AQ7Ryq9xExwrqYNXjRYXnYxD5qlKA4OuqIMGFIzptLcxGzGuab7Cxg6yUCRZO3xfIJkJ qjD8JfgLjIhR/zf7Ly4QZNRsgDrdhZw97mfk7A9lFXVpMUGQWz5FiNQLSy4SkXa1PvHo kWMbCs9s4tMp1s1bxMvJNv8j4iaZw3olALqY14JjzUxP6u7/g6aXfVWCw+ssVI9yH2KG h1+Q== X-Gm-Message-State: AJIora+fCojxyeEsbU4uatc8R0CtkjJ2fI9T44HqjiDbOnCfvS5JhG6M 5lwbzSSHXUGBkUDmrz+OybymbiYdCkqJO2Zv53kHEo0dqhWIgUPwkVFsptxBGZ799ugZyCwgsRN XJSOGAz5hk+5YrJez1NTG61TOW0LM/G0t4AYOYiGyeRftEp9YQ0JyRcgipkahVjxcBs98CNUFhB SxnEVtMY8sdO2Q/FuKVQOCw3Ow0AEAiKD4HDfpeklYQam0h6O0AoI2auDV5ddWgRLjbV05Ofijq InGYLSK3ql0nkmaiJn1F1q/WPlDKkL2sf9oXg== X-Google-Smtp-Source: AGRyM1sbXXizJrqlxRKoyvQ2wd18zWRbjjDBln73BA65dsfrxmjC1Wh+iphvBME78zUupj7JK+WH+Q== X-Received: by 2002:a05:6a00:2347:b0:52a:cf39:59a5 with SMTP id j7-20020a056a00234700b0052acf3959a5mr9301634pfj.28.1657613307434; Tue, 12 Jul 2022 01:08:27 -0700 (PDT) Received: from localhost.localdomain ([114.143.109.178]) by smtp.gmail.com with ESMTPSA id c13-20020a056a00008d00b00528c066678csm6095314pfj.72.2022.07.12.01.08.23 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 12 Jul 2022 01:08:26 -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> <12e2f0cb-08ff-c65f-d31e-76cea1af70ec@joeconway.com> <442d7887-645d-0e31-e971-7a8dc8952d2f@joeconway.com> <20220701211225.GA418166@nathanxps13> <20220702221635.GB1044460@nathanxps13> <20220703171742.GB1048244@nathanxps13> From: tushar Message-ID: Date: Tue, 12 Jul 2022 13:38:16 +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 7/11/22 11:01 PM, Robert Haas wrote: > Oops. Here is a rebased version of v3 which aims to fix this bug. Thanks, Issue seems to be fixed with this patch. -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company