Hey,
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.
GRANT role_name [, ...] TO role_specification [, ...]
[ WITH { ADMIN | INHERIT | SET } { OPTION | TRUE | FALSE } ] [, ...]
[ GRANTED BY role_specification ]
i.e., multiple WITH clauses
GRANT admin1, admin2 TO usr1, usr2
WITH ADMIN OPTION,
WITH SET FALSE,
WITH INHERIT TRUE
GRANTED BY createroleuser;
Personally, I'm fine with any given GRANT command of this form having only a single GRANTED BY specification.
David J.