Re: v16 GRANT role TO role needs a multi-option setting capability
| От | Pavel Luzanov |
|---|---|
| Тема | Re: v16 GRANT role TO role needs a multi-option setting capability |
| Дата | |
| Msg-id | c4152e51-6af8-3ca0-5834-4f3fcc4342cd@postgrespro.ru обсуждение исходный текст |
| Ответ на | v16 GRANT role TO role needs a multi-option setting capability ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Список | pgsql-hackers |
On 23.01.2023 23:09, David G. Johnston wrote:
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/b9be2d0e-a9bc-0a30-492f-a4f68e4f7740@postgrespro.ru
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/b9be2d0e-a9bc-0a30-492f-a4f68e4f7740@postgrespro.ru
-- Pavel Luzanov
В списке pgsql-hackers по дате отправления: