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 1pjnTn-0007wc-IJ for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Apr 2023 20:42:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pjnTm-00025Z-Eu for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Apr 2023 20:42:10 +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 1pjnTm-00025P-0j for pgsql-hackers@lists.postgresql.org; Tue, 04 Apr 2023 20:42:10 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pjnTj-0003sN-45 for pgsql-hackers@lists.postgresql.org; Tue, 04 Apr 2023 20:42:08 +0000 Received: from [192.168.0.104] (unknown [62.217.188.228]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id 3DD8F21CF682; Tue, 4 Apr 2023 23:42:05 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1680640925; bh=MczKAWijPYeDPGq36E7fwWdgO1jW7VumOzuvNzTj7f4=; h=Date:Subject:To:Cc:References:From:In-Reply-To; b=HJI+gXg3k8q4GO/XhxuWOHUiLUs/jO7CZ7mRzBwnBiJyJr4rWZDMwPuljlB3HZVuB FCio4HI0KC/jNI8maN7PwUeErn6xgPwpIzlgVuv0Kl9byQYXCc82GmtbFTJpnPvLfX cTrNBHuw778sQ/rjhwranMWdt7mXIM7YtpLkbrnA= Message-ID: <43b07929-297a-1c1a-521f-32fb15a6a369@postgrespro.ru> Date: Tue, 4 Apr 2023 23:42:04 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.7.1 Subject: Re: psql: Add role's membership options to the \du+ command Content-Language: en-US To: Robert Haas , "David G. Johnston" Cc: Tom Lane , David Zhang , "pgsql-hackers@lists.postgresql.org" References: <20824093-d94f-e5d6-b611-8cec7fc6e95e@postgrespro.ru> <42678ca5-f3c6-db1b-e0c5-c63c3ce8997e@postgrespro.ru> <1525117.1680628353@sss.pgh.pa.us> <1575395.1680629866@sss.pgh.pa.us> From: Pavel Luzanov In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 04.04.2023 23:00, Robert Haas wrote: > On Tue, Apr 4, 2023 at 3:02 PM David G. Johnston > wrote: >> So, by way of example: >> >> regress_du_role1 | cannot login | regress_du_role0 granted by regress_du_admin with admin, inherit, set | Description for regress_du_role1 >> >> >> That seems wider than necessary. Why not have the third column be >> something like regress_du_role0 by regress_du_admin (admin, inherit, >> set)? 'granted by' can be left without translation, but just 'by' required translation, as I think. -- Pavel Luzanov Postgres Professional: https://postgrespro.com