Horton

Re: psql: Add role's membership options to the \du+ command

Pavel Luzanov <p.luzanov@postgrespro.ru>

View thread View on postgr.es
From: Pavel Luzanov <p.luzanov@postgrespro.ru>
To: Robert Haas <robertmhaas@gmail.com>, "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, David Zhang <david.zhang@highgo.ca>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2023-04-04T20:42:04Z
Lists: pgsql-hackers 
On 04.04.2023 23:00, Robert Haas wrote:
> On Tue, Apr 4, 2023 at 3:02 PM David G. Johnston
> <david.g.johnston@gmail.com> 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

Commits

  1. Add psql \drg command to display role grants.