Re: GRANT ON ALL IN schema

Tom Lane erote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
>
>> Why don't we tell people to write a plpgsql loop for the schema.* case as
>> well?
>>
>
> Indeed, why not? This all seems much more like gilding the lily than
> delivering useful new capability. The default-ACL stuff that Stephen
> is working on seems far more important in practice.
>

I agree that Default ACLs are more important and I already offered
Stephen help on that. But I've seen countless requests for granting on
all tables to a user and I already got some positive feedback outside of
the list, so I believe there is demand for this. Also to paraphrase you
Tom, by that logic you can tell people to write half of administration
functionality as plpgsql functions.

--
Regards
Petr Jelinek (PJMODOS)