Subject: Re: v16 GRANT role TO role needs a multi-option setting capability

From: Pavel Luzanov <[email-masked]>
Date: Tue, 24 Jan 2023 00:07:58 +0300

On 23.01.2023 23:09, David G. Johnston wrote:
> GRANT role_name [, ...] TO role_specification [, ...]
>     [ WITH { ADMIN | INHERIT | SET } { OPTION | TRUE | FALSE } ]
>     [ GRANTED BY role_specification ]
>
> It would be really nice to complete this new feature of INHERIT/SET 
> FALSE/TRUE with a multi-specification capability.

If I understand properly, the multi-specification capability is 
supported in the form:

GRANT admin1, admin2 TO usr1, usr2
WITH ADMIN OPTION, SET FALSE, INHERIT TRUE;

But this doesn't seem to be reflected correctly in the documentation.
If I'm not mistaken, the current spec should be like this:

GRANT role_name [, ...] TO role_specification [, ...]
     [ WITH [ { ADMIN | INHERIT | SET } { OPTION | TRUE | FALSE } ] [, 
...] ]
     [ GRANTED BY role_specification ]

By the way, there is suggestion to add role's membership options to the 
\du+ command.[1]

[1]https://www.postgresql.org/message-id/flat/[email-masked]

-- 
Pavel Luzanov