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 1oT9RN-0005Fl-TR for pgsql-hackers@arkaria.postgresql.org; Tue, 30 Aug 2022 22:10:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oT9RL-0004Y9-T5 for pgsql-hackers@arkaria.postgresql.org; Tue, 30 Aug 2022 22:10:35 +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 1oT9RL-0004Xh-IY for pgsql-hackers@lists.postgresql.org; Tue, 30 Aug 2022 22:10:35 +0000 Received: from mail-pf1-x42d.google.com ([2607:f8b0:4864:20::42d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oT9RI-0006Z6-EY for pgsql-hackers@postgresql.org; Tue, 30 Aug 2022 22:10:34 +0000 Received: by mail-pf1-x42d.google.com with SMTP id y141so12687706pfb.7 for ; Tue, 30 Aug 2022 15:10:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc; bh=BIjJ3yuo0YztMXv99K5XScRKeXoIUvhljV8artRkkYQ=; b=ETywaiV8bdYhY6m5eVDeH2veRQnvpOFn8MLZo7j85eysK4wURl9Ta1vDVj+C+csgAJ 8N6Y7I8h1o74ESkHsPyQCdbVn6fu9kGy+FirMfGvOr5x2r0W2hIwfj6HaZZIZ+dzbx6L FvrB7FF/9myv/LkQNQBEjr+uLAwEsoHfKxhgtsXz/St1juZTJWz9+28BAWj8DLw8oHLp +sOPbTeFluhR1tC8OWUMZPi3AKSCFTugMjUpOWf7G0PWUECeUS2A8sU7ifbp/zx8DBUH 8MklBqlUd3jInbdS4ld5seQRTgnTKT9lKM83SDzdy+KZgMHkhvY6/qeT5ggrFU2iFFVk UrpA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc; bh=BIjJ3yuo0YztMXv99K5XScRKeXoIUvhljV8artRkkYQ=; b=SDIZeafggTO46cgbZsRBmyoyvq8GAXNUqIpAbCrJsRuSJeYVbZ2sUPq/6jr5Bas443 RcmnYFvEDisw8BBLGVZDtH+lOZqU7lCYd8JmV1842bxQv6Od+LHHwOuIeTMO66ZhHOJh TPSdfTFpFr5i4cU+k1l56JDTTg5m66BKi06YPLoSJ9CnTGYFOt0HQOdA/10mTRGRhnAR KuGWw/z7FMalUwwkQTTA+HstUHoMr1bptnOVFiD9GHntmLV2zaQj8S0LUfdKOmtVpFF3 BJ+bKm6wWiPdqGAqkv8xM4kojokh2oPm3+YCl8ugOg6tMZusbV3owenFgEwJCMS9qx49 lorw== X-Gm-Message-State: ACgBeo0F+Epo7Q3I6OY/j00dGxd7VHi7e4vm2J5ftfhP6TGq2whPruIJ Q0b7k4AyxXy5yDANR/Nv10A= X-Google-Smtp-Source: AA6agR5qc/vkWvCkJaixl2D0QkLQxbwkhjonvytezJymXq8ZpAxsZRJhdV/DEuFW6soQMzLQL/KEmA== X-Received: by 2002:a05:6a00:1a14:b0:52d:5fee:d46b with SMTP id g20-20020a056a001a1400b0052d5feed46bmr23280352pfv.82.1661897431309; Tue, 30 Aug 2022 15:10:31 -0700 (PDT) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id q5-20020aa79605000000b00536b8f91806sm9785946pfg.198.2022.08.30.15.10.30 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 30 Aug 2022 15:10:30 -0700 (PDT) Date: Tue, 30 Aug 2022 15:10:26 -0700 From: Nathan Bossart To: Robert Haas Cc: tushar , Joe Conway , Tom Lane , "Bossart, Nathan" , Stephen Frost , PostgreSQL-development Subject: Re: replacing role-level NOINHERIT with a grant-level option Message-ID: <20220830221026.GA596674@nathanxps13> References: <20220828211421.GA213902@nathanxps13> <20220829220419.GA539509@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Aug 30, 2022 at 08:33:46AM -0400, Robert Haas wrote: > Third try. Now that I have this grantor stuff fresh in my mind, this patch looks good to me. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com