Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id C631B634D42
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Wed, 17 Jun 2009 12:00:40 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 78684-01-2
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Wed, 17 Jun 2009 12:00:19 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp-out4.iol.cz (smtp-out4.iol.cz [194.228.2.92])
	by mail.postgresql.org (Postfix) with ESMTP id ABC48635B92
	for <pgsql-hackers@postgresql.org>;
	Wed, 17 Jun 2009 11:59:40 -0300 (ADT)
Received: from antivir6.iol.cz (unknown [192.168.30.215])
	by smtp-out4.iol.cz (Postfix) with ESMTP id 0AE9ACE4429;
	Wed, 17 Jun 2009 14:59:39 +0000 (UTC)
Received: from localhost (antivir6.iol.cz [127.0.0.1])
	by antivir6.iol.cz (Postfix) with ESMTP id DD216720056;
	Wed, 17 Jun 2009 16:59:38 +0200 (CEST)
X-Virus-Scanned: amavisd-new at iol.cz
Received: from antivir6.iol.cz ([127.0.0.1])
	by localhost (antivir6.iol.cz [127.0.0.1]) (amavisd-new, port 10224)
	with LMTP id bODU+-TRmgyN; Wed, 17 Jun 2009 16:59:38 +0200 (CEST)
Received: from port6.iol.cz (unknown [192.168.30.96])
	by antivir6.iol.cz (Postfix) with ESMTP id B584A72005B;
	Wed, 17 Jun 2009 16:59:38 +0200 (CEST)
X-SBRS: None
X-SBRS-none: None
X-RECVLIST: MTA-OUT-IOL
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: ApACAEeiOEpYZzAw/2dsb2JhbAAIghwv0wOECAU
Received: from unknown (HELO [10.12.0.96]) ([88.103.48.48])
	by port6.iol.cz with ESMTP; 17 Jun 2009 16:59:32 +0200
Message-ID: <4A3904CC.1020105@pjmodos.net>
Date: Wed, 17 Jun 2009 16:59:24 +0200
From: Petr Jelinek <pjmodos@pjmodos.net>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers@postgresql.org
Subject: Re: GRANT ON ALL IN schema
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>
In-Reply-To: <26370.1245250052@sss.pgh.pa.us>
Content-Type: multipart/alternative;
	boundary="------------050004090103000907050104"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL=-0.000,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200906/1062
X-Sequence-Number: 140117

This is a multi-part message in MIME format.
--------------050004090103000907050104
Content-Type: text/plain; charset=windows-1250; format=flowed
Content-Transfer-Encoding: 7bit

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)


--------------050004090103000907050104
Content-Type: text/html; charset=windows-1250
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=windows-1250"
 http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Tom Lane erote:
<blockquote cite="mid:26370.1245250052@sss.pgh.pa.us" type="cite">
  <pre wrap="">Peter Eisentraut <a class="moz-txt-link-rfc2396E" href="mailto:peter_e@gmx.net">&lt;peter_e@gmx.net&gt;</a> writes:
  </pre>
  <blockquote type="cite">
    <pre wrap="">Why don't we tell people to write a plpgsql loop for the schema.* case as 
well?
    </pre>
  </blockquote>
  <pre wrap=""><!---->
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.
  </pre>
</blockquote>
<br>
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.<br>
<br>
<pre class="moz-signature" cols="72">-- 
Regards
Petr Jelinek (PJMODOS)</pre>
</body>
</html>

--------------050004090103000907050104--