From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-hackers@postgresql.org
Subject: Re: GRANT ON ALL IN schema
Date: Thu, 18 Jun 2009 10:21:36 +0300
User-Agent: KMail/1.11.2 (Linux/2.6.26-2-686; KDE/4.2.2; i686; ; )
Cc: Robert Haas <robertmhaas@gmail.com>,
	Guillaume Smet <guillaume.smet@gmail.com>,
	Petr Jelinek <pjmodos@pjmodos.net>, Tom Lane <tgl@sss.pgh.pa.us>
References: <4A37BF63.50008@pjmodos.net>
	<1d4e0c10906170925o5001f808j8e4e49b5c620c788@mail.gmail.com>
	<603c8f070906171027v29124841g1a73388f24a84540@mail.gmail.com>
In-Reply-To: <603c8f070906171027v29124841g1a73388f24a84540@mail.gmail.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200906181021.36835.peter_e@gmx.net>

On Wednesday 17 June 2009 20:27:20 Robert Haas wrote:
> What to do about wildcards is a stickier wicket, and maybe we need to
> decide that first, but I really don't think we should be discouraging
> anyone from investigating this stuff and trying to come up with good
> solutions.  There will always be some people for whom a custom
> PL/pgsql function that directly accesses the catalog tables is the
> only workable answer, but we can make PostgreSQL a whole lot easier to
> use by reducing the need to do that for simple cases.

I'm all for investigating it.  I just have my doubts that "grant on all tables 
in schema X" is a sufficiently general use case, even if you only concentrate 
on the simple cases.