Just my two pence contribution:
> * Allow GRANT/REVOKE permissions to be given to all schema
> objects with one command
>
> > GRANT SELECT ON TABLE myschema.* TO foo
As for the style of the syntax, maybe one could consider to reuse
already available sql regexpr rather than import shell-like regexpr?
GRANT SELECT ON TABLE 'myschema.%' TO calvin;
Also, there is no reason why the schema themselves could not been
fixed similarly:
REVOKE ALL FROM SCHEMA 'abc%' FROM hobbes;
On the other hand, having actual sql regexpr may make a potential
implementation harder wrt just handling a 'myschema.*' special case.
Have a nice day,
--
Fabien.