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 1kIqjk-0005GH-PH for pgsql-hackers@arkaria.postgresql.org; Thu, 17 Sep 2020 10:01:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kIqjj-00046O-Mk for pgsql-hackers@arkaria.postgresql.org; Thu, 17 Sep 2020 10:01:55 +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 1kIqji-00046H-Uc for pgsql-hackers@lists.postgresql.org; Thu, 17 Sep 2020 10:01:55 +0000 Received: from [66.111.4.238] (helo=forward4-smtp.messagingengine.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kIqjf-0001Fu-7Y for pgsql-hackers@postgresql.org; Thu, 17 Sep 2020 10:01:54 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailforward.nyi.internal (Postfix) with ESMTP id C8FE819415A7; Thu, 17 Sep 2020 06:01:39 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Thu, 17 Sep 2020 06:01:39 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; bh=R+CQPYX8mxwvk1cs5ZQhQ5iX5Ha4Fyp/eoBZIPE/r Lg=; b=gI2HGYGZWflbPYP+TRPzTPZxiUYN5vwVhIJN3I3J1zrg/FdKENvXgUM3a N9+88YvK9RJbnWXm+oA2GNW9KboZNBtSWH9Aw9M803InuK7lw6SA8nFnr2Bc6iiU UGpEOuT3XO96zQ2MECuq1GkgJZtjWrb44rPT23xaNEk0upHTJpBnQYqCikEwKoLL 9CetymVBn7BQOzZBYdMVA0xK25h6HiopwpOiowHQNo3dIOR+p1ZgQqhhndN4jeat Y9iGxmgUwZ2FxjKSVigdAg9iXnu8LHkyQuPkeV3GZ5WaW3cZ7kqa8SbwCJr2qMSt B13ynJKC4bupLaLXfSCdU2Cq0jabw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrtdeggddvfecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefuvfhfhfhokffffgggjggtgfesthejredttdefjeenucfhrhhomheprfgvthgv rhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghishgvnhhtrhgruhhtsedvnhguqh hurggurhgrnhhtrdgtohhmqeenucggtffrrghtthgvrhhnpedtveeghedtjedvvedvleej ueevjeejtdellefgkeelfeeikeejlefgkedtudeuvdenucffohhmrghinhepvdhnughquh grughrrghnthdrtghomhenucfkphepkeejrddujeejrdejiedrieelnecuvehluhhsthgv rhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhdrvghishgvnh htrhgruhhtsedvnhguqhhurggurhgrnhhtrdgtohhm X-ME-Proxy: Received: from april.pezone.net (p57b14c45.dip0.t-ipconnect.de [87.177.76.69]) by mail.messagingengine.com (Postfix) with ESMTPA id 1ABA63280065; Thu, 17 Sep 2020 06:01:39 -0400 (EDT) Subject: Re: Allow CURRENT_ROLE in GRANTED BY To: Alvaro Herrera References: <20200911200513.GA1096@alvherre.pgsql> Cc: pgsql-hackers From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: <9af2d823-d175-01de-413c-8a31ebc398b6@2ndquadrant.com> Date: Thu, 17 Sep 2020 12:02:35 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <20200911200513.GA1096@alvherre.pgsql> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit X-Host-Lookup-Failed: Reverse DNS lookup failed for 66.111.4.238 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-09-11 22:05, Alvaro Herrera wrote: > On 2020-Aug-26, Peter Eisentraut wrote: > >> Here is another patch that also makes comprehensive updates to the rolenames >> tests under src/test/modules/unsafe_tests/. > > Looks good to me. You need to DROP ROLE "current_role" at the bottom of > rolenames.sql, though (as well as DROP OWNED BY, I suppose.) > >> I think this should now cover all the required ancillary changes. > > \o/ > committed -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services