From: Petr Jelinek <pjmodos@pjmodos.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers@postgresql.org
Subject: Re: GRANT ON ALL IN schema
Date: Wed, 17 Jun 2009 16:59:24 +0200
Message-ID: <4A3904CC.1020105@pjmodos.net> (raw)
In-Reply-To: <26370.1245250052@sss.pgh.pa.us>
References: <4A37BF63.50008@pjmodos.net>
<200906171644.53717.peter_e@gmx.net>
<25515.1245248104@sss.pgh.pa.us>
<200906171744.24456.peter_e@gmx.net>
<26370.1245250052@sss.pgh.pa.us>
Tom Lane erote:
> Peter Eisentraut <peter_e@gmx.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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: pjmodos@pjmodos.net, tgl@sss.pgh.pa.us, peter_e@gmx.net
Subject: Re: GRANT ON ALL IN schema
In-Reply-To: <4A3904CC.1020105@pjmodos.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox