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 1oE3iJ-0005Og-SL for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Jul 2022 07:01:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oE3iI-0005NH-5o for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Jul 2022 07:01:42 +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 1oE3iH-0005LQ-9z for pgsql-hackers@lists.postgresql.org; Wed, 20 Jul 2022 07:01:41 +0000 Received: from mail-pj1-x102c.google.com ([2607:f8b0:4864:20::102c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oE3iD-0001mC-CP for pgsql-hackers@postgresql.org; Wed, 20 Jul 2022 07:01:40 +0000 Received: by mail-pj1-x102c.google.com with SMTP id q41-20020a17090a1b2c00b001f2043c727aso1265294pjq.1 for ; Wed, 20 Jul 2022 00:01:36 -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=QROV2/scw+CfOCCVJiitFn3VIFKIq27wBP9Q8EohVkU=; b=HiexDGCA/Meimz7PB6nYmdrgH8ZKZKqioVAKpHfm+vvdoE3CL3xj7eUmfNpPYb/eQj fjX34PS+x8MYKdoJZRvlP/iOonxIpelxJxGQb/bPy5VZTcUP4plj8CBd2trHPRWar9e3 l3EPCi9O2sM231Tg+dodmqUR2hs/JLAfxB7WnbAAT4KtsVTWxZllNcQlK3pIZMiU2NIx qq59OWQJ1OKrK35TW9ls53wUPh3z1CkCGhnaNHl4kC5alqOjDhco7VPjTA+sUUaIMqZo 68G9AsXJ19WLjvHB5kfdoPlTNXj8TLedh0bixNs7Bo0g2XUwJiRcnRUgoMrvg8Saxv8S /taQ== 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=QROV2/scw+CfOCCVJiitFn3VIFKIq27wBP9Q8EohVkU=; b=zkFxOzhmR7h7nLeUlXm3cYZ7WM9sagt5lYTpw8+wTV+hs/0HKTtM2i/a8khEYS8Kx/ ysgNurzuryweQEg10PJpKe+SKO9KzFwR9WlY2x08DYBfSDSeXGpO634FrUIAzctuKwVL 8ts1Nq7FJmFGGA7A9sYoN8NYW31Go6JtZ14j9TDQBPYEMfapEJwDxqIkYreLGqtADf9G y1W0IQi7cxDzOlUgD+EVW4aYLfmHCq96LWQQ1sNlxYAp6tZJo2ZCwRbC/GHjjd+3LWR9 VqBrwvC52+xLvu8QFa1GNw5RFmeHedZ00ZjddiHs+f3pnCSOdGE0GrHFUX5fXmoFOMHJ L+MQ== X-Gm-Message-State: AJIora+Yk/IXcXEGUd9fyZmruPBFhaa/Ss/bOeHcr7/ss92HA2b23chj lsBnRS9OiS/6GtJk2sF0URtTCtnKru2+IxHXv77c54gtGQq5PVqDabm7B2S5J0Jm5bCyQHo1ZF7 0ZYZw1W8BReF9CMRq20bBG+L+c0RWngV4I6SJ21CLGQicIt68CZmstLquTTUefRwSSYF4/zVlZ8 802k9OoUmtSsozdG8CjLTT+9ZSoYF3qq56G3DmN8e4ELXbSNHprT4XXpioaNsDQDFu1sWd/kUma 5r2TQsLhWL+cQJvQIJGA5DaIdxCecFk5OpUvA== X-Google-Smtp-Source: AGRyM1vblqhToUEd52YyIPd6h22EXXsV77gdl9DTKh3vKp7V2POVO3CmxDGu7uPPxRkvulidH1ooqw== X-Received: by 2002:a17:90a:ab8e:b0:1f2:1ffe:51ed with SMTP id n14-20020a17090aab8e00b001f21ffe51edmr860207pjq.28.1658300494607; Wed, 20 Jul 2022 00:01:34 -0700 (PDT) Received: from localhost.localdomain ([152.57.240.65]) by smtp.gmail.com with ESMTPSA id m22-20020a170902bb9600b0016c5b2a16ffsm12891981pls.142.2022.07.20.00.01.31 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 20 Jul 2022 00:01:33 -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> <442d7887-645d-0e31-e971-7a8dc8952d2f@joeconway.com> <20220701211225.GA418166@nathanxps13> <20220702221635.GB1044460@nathanxps13> <20220703171742.GB1048244@nathanxps13> <8210e573-c861-fe45-302b-56d7352aae48@enterprisedb.com> From: tushar Message-ID: <7f6e52a8-1117-feb6-1489-100c4f7a4cc6@enterprisedb.com> Date: Wed, 20 Jul 2022 12:31:29 +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/19/22 12:56 AM, Robert Haas wrote: > Another good catch. Here is v5 with a fix for that problem. Thanks, the issue is fixed now. -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company