Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 30339633198 for ; Sun, 9 Aug 2009 20:14:45 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 52048-05 for ; Sun, 9 Aug 2009 23:14:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from phoenix.advel.cz (phoenix.advel.cz [81.0.239.26]) by mail.postgresql.org (Postfix) with SMTP id 86642632C7A for ; Sun, 9 Aug 2009 20:14:41 -0300 (ADT) Received: (qmail 20140 invoked from network); 10 Aug 2009 01:14:39 +0200 Received: from unknown (HELO ?10.12.0.96?) (88.103.48.48) by 192.168.1.50 with SMTP; 10 Aug 2009 01:14:39 +0200 Message-ID: <4A7F5853.5010506@pjmodos.net> Date: Mon, 10 Aug 2009 01:14:27 +0200 From: Petr Jelinek User-Agent: Thunderbird 2.0.0.22 (Windows/20090605) MIME-Version: 1.0 To: Tom Lane CC: PostgreSQL-development Subject: Re: GRANT ON ALL IN schema References: <4A37BF63.50008@pjmodos.net> <4A37E122.8070303@pjmodos.net> <4A38A956.8080600@pjmodos.net> <4A4DE104.8090605@pjmodos.net> <4A6059B4.5010004@pjmodos.net> <4A607997.3030305@pjmodos.net> <21542.1249492707@sss.pgh.pa.us> <4A7F56A0.5060705@pjmodos.net> In-Reply-To: <4A7F56A0.5060705@pjmodos.net> Content-Type: multipart/mixed; boundary="------------030009070406030507030000" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200908/727 X-Sequence-Number: 143370 This is a multi-part message in MIME format. --------------030009070406030507030000 Content-Type: text/plain; charset=windows-1250; format=flowed Content-Transfer-Encoding: 7bit Petr Jelinek wrote: > I attached revised version of the patch. Changes, thoughts: > - SCHEMA is mandatory now > - removed VIEWS and GRANT ON VIEW since it looks like only me and > Stephen want it there > - the patch is now made so that adding new filters in the future won't > mean tearing of half of the parser code and replacing it > - I decided to go with GRANT ON ALL IN SCHEMA syntax, because I am > thinking there is no difference in adding extended syntax to the > standard command in GRANT and in SELECT, ALTER TABLE and other > commands we extended. And I don't see any way standard could add > exactly same syntax for doing something completely different (which is > the only way they could break this). Argh, why does this always happen to me ? Immediately after sending the patch I realized there needs to be one more little change done (merging tables and views in the getNamespacesObjectsOids function). -- Regards Petr Jelinek (PJMODOS) --------------030009070406030507030000 Content-Type: application/x-tar; name="grantonall-20090810v2.diff.gz" Content-Transfer-Encoding: base64 Content-Disposition: inline; filename="grantonall-20090810v2.diff.gz" H4sICIxXf0oAA2dyYW50b25hbGwtMjAwOTA4MTB2Mi5kaWZmAO1ce3fauLb/m34Kna7eW5K4 BIN5NTNdywUn5Q4BxoZ2eubOYhkjiG+MzdjQNtP2u9+9JT9kMI80mabtnMwU23psaf+2tB+S 7Ik9nZJnz2b2kpinE886DXz4N5s7pz6dns58010W8JGMd+U+st0J/UDG00a1PK4XCvVyaaJU KJGLxaqiPDo+Pt5N/dGzZ8/2tHCc/iN9L1jOfGr82iFQbTWn7tJc2p7LGiuVpVKDYLlHhPwU 3LjeIrCDF/BwoavdAfkI/xlaR2sOyCfS7hqajjfDfksdaHDTgix2M9CH3SZP07VzTde6Tc1g 6e2LC00nn4Ei/v0uFQqFPyBD7XTI76Svt1+3O9oFlP0DyvyLlel1IWegvuxokPiTTxeOaVFz 7FBiOWYQ/Py4r+rqJbSrP36xxHTXnNOfToWCL6Adgg2FrQ56wMbvwFJv2N9P0/cySX4i/eHL TrtJPkfUgeSb9uBVCFWvP2hD17HNQ+EToPpM8vv6ZXnOau5mM0qO2MgAcZaLMEqfPfumxPnx /gTKafIGGUkD+CBG85V2qe6jHVhXdG5uJx6z9Y8YL+t64tAeML1RhoEW641U94eGeoElYyJh 3VsOGUP7dYic7pUp/XNFXesb1wFNXeP4NXvdLodloF32e7qqvw3vGcld0OD8LiuSIkfz+++A /eN9Ai/O1YjsDzdd70O026ZiJNRtlYjSkCqVaBo+MBTab1pzONja3XiInYNpYfXFzr2Yrlwr oyt5IPR7JhsL04fiS+o/fmH6s7k3Wa/6x0EVM9rMhi1dbXmz2DYqQbd+O6pn5whCjVKRpUo9 0ijfyQj6+I8aQ6IWjfj+wbToPj2XoRz3d48pSFkpS7JS5yoSx7usVCW50khG/E+nKJUXvEPw yJ9OGCJX1KfEDojpBB5ZXlGy8ILAHtuOvbwh3pSwqMt2Z2RB/bkNWZ4bkKUH5R3ijf+PWssA inFiM/sddQnKnNhuYE8o8Vz455P5ylnaC+CCSyooQLvQJg5mDNNM1hgkBKvFwvOXdMLpTaEq c5YDibyz6Xu4RCYZOuxOYgL8yTJdCP+gxfENWQXQZ04FEf/I/ehPsYn+FA+zz8I4SwYSgcBi aX4APgiTAScFeHCeCZYpsMQI3BPCHyOoObghnMD6wrff2Q6dYdd9+jwSBvnpnenbyKRjB8sX jyY7Y3CfvvOu6dYgXMgOo/D6pFqq1IuFglKs1CeT6p4oXCSwJQwXi9wuDlcwcAsNua697v2i sbkozJnznk4ii/JjhOXneu/yb9E5EVekqRpNtcXZN4BpwIupHhYrA+SxL/3NQv63h84pC3qw sXg40a1Pq12SY5FqXVKU282sbzWEfdj5Um5ISvV28+W7Ckp/9IlQLUnVurBkc4gI/xPTbYvp HnYuVhWpJq4D3acs/xNdfZfqIOUbo1M6Nq1r6k5OLXNpOt7s1LQc6+q6YIHfuis79I2ppZjm FHzjSb1aKZXrad94JwHuG+8ssq67AnSFLfLOsydE+0CtCwysRl0AJlgAKPm2C2KFUIgrMlmq VpOIDh/jFYxsQgMWJ6UosQxyzCI4YzlfHp3xmRQS6EC8QY55PMO6MfB69iTIs2o9ljzAUA5K 4ECTkgoozQConaRJzegyZifgBIJDKLrBYjtFnToshAjaboIVUGURGHtqTyRiXZk+8alzDZJl bIog0Q8LCA9HlueMkiAsz1uAREZIIkiTuZcjqCMBiRz+QfhoOZcwryE2tgOhfkaJ43QL0sYQ QGmtlvQiEkg+viPHAQqIx0n1qlRqlCIzliPHp3ixsUQB+sDkSX4m+PzsRZRwlpQJ4Y2LhM9n oAiSEixw/5lsij9VR0pIYAUGbe70GKN/xilbChhTMrUdh07gzvHeh/2FUkLIu7UY71CEHHap 2+6c5bD63LwhMAI2arHIpl6HaDL21e4VJMQpeG8vrSsSosEqY/YR5n3En5xlBpTbotHgbV8b 9V7+z3OWcXeMGZWxT83rs8ymQJGP2t0RX7TY0ujWyXjLtid0aq6cZdgKiGCW13S9p0vk8cr1 qeXNXPsvkA4HHGk+J/81eRwRTpBj5NAGfwtDaH1mHqoFuXIuNqSqrAjquVSWapXYWcn5dLny 3Wh5DAcd2k6+QnR6jMtEx1vlw3J5kQvoeHqZjZjiGtvU9+YkWFDLntrAHDfgBJeRiO3iEp3L lBomsKUq4HtNv8LznZU20PgI/3KYDMowsiiRGKKsJgVOINeCK0tElc3Kh5RYIrQMo0xQ7Wcc tXg+hr3AVnOsWT451GYHJyBEYCNd66jo4TxnubmpB2PZuspjuxIRew2ZnEIu6bsfWZuk92GR sCbTF/5r08k7U9sPlozuEbNcuXTPoWTH865XC+3DwrEtO4E5H9I6EsiLDW+zeimLB2z+0u62 YnbjLiTwo+DB6rngmuTDVInEDd1L66/b2psvaxnKf+aXUNlkyTIKXv8hsozYFYndP6hRCHAb UA3LdH+hNy1wcsk1vfld/iNC6RU1F5jbooEFKsh0xYzBauHQ3BJ/o+QIDUTp64kk7H/btZf5 /0YGin9IYRb8qe5qPlrMwHx4Fv7EzQhlXg60P1emYyx9c0lnN93VfEx9iZyPeu2W9qtQkKvM 9gS0N8C1mouiPlobJsDEFcA08hbUzfehdTpZ+TSCCIeGaoFaDgzQlbTjWddifQQ7IjCmM9vF hDxQlYjhmovgylt2vfcSkSUUmVjz/RWYVJLPM8FEJGCkuvTDMo9UgC/Pf2/6EyZZG8w89ufo iPwLptKw0wlHRzw8xFFqLoCZCTrRySiNxwKAAiqeN5yI9XPSNdYVqM94wR+x3yzTcryAcjaz wMmcArETc7LbiYn98cg95L5M2DzJg1k9igwhby3q+rrJPyFhL9ImP0sXCBZf51SYCQdrnygS 2w0NfzyY0KWBMA+dmpu4IMH4Z5ep/4JoasO+Z+jVDf1Q4vohWzlkaYYstbBj0kYzlq02jKDO xpQ9bL4eNlk3OiJv7whitrcPzVeqnnSiCXDHHYhgjxtfVxMRUodoiUNVRCmtIu5HP3DlII4W UTfE6bu1QzS/tuuFQ5SCMEPjdqM5iv8TnKM4trPXCljW9tUnF4L/4NTyFje4fhhsLD9t5Ifr T6VKoypP5ELBLJbMerm8ff1pk8LmAtRmmfUgZ4SZmYsPGEmEiw+lekMqlRpCdBMlVYTF2Fyz 138LAajaUfXReVvrtPJRjM3XCDbzU2pzM1sMFKP63V5LS2onCxDrmYmksvMZbcpy9wiR4nzd JUWxQChGWSmZZn1aKBTrVJGB/B4xpkhsk2Oq0IYgWW6mJE0pMWJs/4Q06kWpUa8k8uQJ8dLJ R47YZR9U0m6JZhRZE2pGiQ258jLbRbuRvyndjSKHCHhh+gH18S2CeeFmDfNUXihWc9owqVkE scr1anlc3S7WdO1Niabz14TJZVSV5GK84odogceCnvDKWpI+8D8wfdC/kbS2hOZshUUMw/nS g0AgXADmwwDbLEej4E5tsjxMzeVicac6Q/Z1aMtiOdJEP4Ucs+Xtc5gPURJfv2XoKdWGpNTi M6I57bdmZ9hqdy8IuzPar7V4Z0j7rW0MDLj0O2q7C9eBpnfVDt7oanMQardztWNooz45Vy/b nbfkXBs0X5Hztm4MMLHTU9m11+n03mAzuAkF/5oa/mrtC7Yt9UbVW4jBua5p/9b4rsn5UNiC Cdu66PReQgf4rhb71VpwxRO3xoDvsYz6kdCUWhFYTZY9vxNWk22n2zJ9p4FRKdakihyf4c/x tZLXyC7caqqhwbWrXuKlD22zMyhw21Gb/NpuqrgFpQ3YRpSqDziVcE9K1wZDvYuo8Dsj2qPU 2xevILuH1AC5l2rzF7h5g/+gzLCjIWeAl6G+1vq9NkAQnj8zmlieGJqqgxQMrdnrtqCzcDPU 24O30SGDaJ0Ae2NoelvttP/N+g4PrzUdLobRZqcz2HU0NFgiVhz0zomB3ier+wo6ZbRB8KqO 1z6SuFQ7HdalHuBicEzg0m2pnV4XoWNA4O9Au9S6DBJ8gMHWbhqQ3sLzdINWb4iFejoej+CA sbp6u4/X4Uu8BeiMYV/TsYNM3jnj7eWlhqWJ8dZot/AXmuFjARDj3eEne/ooJXb2HH86eOgi OZU+gFEO7QxeaV0yaAMn+APdvGStDHoE5kC7gx2Am66h8mE6wBEYH2OC6yWeddJ41+JTT3Bj 4Hhla/Hx1KwU61KlFL+Z9MMNtuQkyT972H17o29dR8YO4PMcV7DCJgo0Ez9x41lSShL81BIH EZ7KmBSfIGZLPG6yjQahHLgJ9EzIEpr4mTwpiVnJTlv+iXIk7LSdxEViryEuJPgRKUrhKlNM KRDzIzcQu1DdyIDwma2RQGbtbAM0nR1rZaiFuFTqAEK1LOJSLWJSdR2XNfJT0wm+I3DG9Mp8 Z3v+wcDUZEChVhWBqSmQVC/uAWb3oKlsw6V2CC61Q3Cp7cGlsQ0XubgJTNz70ZL5siE85QpM nnJFOI8PTzVIqpZFeD5GLSXOMDlGkPJiwhFZmI7jWfnA/ot6UyHv6CgbroydsG2gpTev18gx POQ48ckTeHajx803FraBgTOmXK2IYFQrkJQc7fpuwCjdHQwcBrWSCEYNB0ut8ZXBiEz5Q4KB KgM5F8Cog2Ip12tfGYzz1psvx0G5Mw6c6WoKB4hny8l629fCgQd0I+7NfTkk5btDUkf+Rctb bsDUUYpfW4NGYetDzpNGBTkvCmAoRUySv7YGbWHMAmHMA4KhFEsIhuirKnIZwfjaGrSjdi+G EGM8KBgN5FwRwSiBMgFv7CuDgVEtC4geEg25yllnaHw11pNg8HZc4ZUtfj7D9bDQBx3hxu9z XiZMykV/HwkjwQ6BzM1rKuefyEdnhFPKfUqRIE+lp0QgENXl229QUQItzSqHowYHUlX5yqNG hO7+h80JhyX1IhiuAPC1D9zmZVCtH2S4A7snu9m9hQOaOt+5RjgKlU7SbJ9ssi2++fOgnN/C 27wfzsWXHB6U81v4D3fgPNYlD6hI1rU0HqsJqP+OTkbX9Oa950+4npaLeHIbfkX3Ti6WSxXc jSqLPs0nvtEgPLB9hugx2kU5ST8bUQG+xRA/8T2G6PGV2m11NP0W3UYPVC4qxZLYbYjsMVFJ dztaShWe2Ypq8hwu35+kn42kQLK4KqSBV548sSXWW/RfkVn/S+n+V3ATUKmW0v1Pr42yJFwV FR744mjYf65fo9xErccp2mVfvMfF0s19Wtu1nNWEhvvfbM+U3Rauwu3U7QXid90rVrFSLxSK k2qtXsvYsd1BItm23VFoHe5o15S6qzlZ2yHluMuNsiSXiuJg50lysliWaRPZ8fVl/FIPP+r+ eb0RNu1PMvrBehCe3EqbUYmIf6dsS82dmH50hN+LjprxhbN8cMRPk+W2KauQTFx77ch6+DmI kCg/pB4T/Zz09owfxFnbiI7Xsh+F+9BdEMXAnOVy8Trf2PMcfP8hfMWDA+evYv0q8QVZeAx3 TPhbA9s2tLE6nsASPvYwpvgBDG9B8RzXBHkMEYn3vZOVR948Izhl39PguFjefA4w4wcsKEtm ojLH3rtQtBvn5zml6Cigbroz+tr0CRuKEsEdzzf28kr1Z0GYFnlC8EeO8asbC8e0wxODJG8G 5LXpACoALHDDBSA2myzGplvm56nQ7PF2sN7WyRsedbh+z146WJ+5a7nhtK3WaMMaK4UCzN/J pGFtn7br9Tfn7HqJ9Qnbvxj9or1909Nb+cdTn9K/6GPAkm1bS3xHBe3IqMsnbxUmalX8sApL iEPNNDFvzkj1LiW2iwfauhVlH60XXjkOFh52OqlWIYzaXoV/6YRV45ZOIsPuZksnmdUCoZ6R XTHd3szxxiZ2kpvRg6rgQMcafNIdVJxOogpaK7uNXRIMqOW5SCGyuAIJJsFyqS6Vy4LyLUOo Uy5XsiQIxFa+vbzh5JjBPoTrgDowW1kl3C7dz3f0/j6rwg3/IZKMP3wj1DtIkjAfbNOx/0JT wuomvsWB1d9Rn1cEB+SwKuwzQawOc1O+QLI38zkFRWUhkWhvNsSWSxY8l3JVFiRbAVEnMWya WGCzUYJOzEEM3ARLOuc1mKdzSKVlCPCAI7tPnty0R+UPkmTiDcTV0FM4qCqdL7ASeF+HFnfA 1oVV0GHLrrZhCJY0WJ76dAZuaHBKPyxgbtDJaWJbCt5qGersQ4pGnl2xMa5WqmAiGrXKdFrc NBEHEUvsxUHF1wdoeCDiygxG/EXhuHz+aUhrBdNFZt2qyxWpXhKWbVlCsqdO0KPJy8T33h9x Jw7KXGzxoVIf1iJm6EVBHX5eJDp4oQ4Hr3o6zO0o5gwdHoyJMTvre7KL1dixLX5mS2QCqx/K 8FOJPDURUnbHaz2FsBA4Yq4XvpGQQYTxnPGHxfGLYhE67Iz2JitZH4rbzc0WpLbxjRyhAS3l KxEztgPZ7NWR50T4IhqZUBdfwcQPlkUmN6m+X078mMYBYhr07i6k0oaQ0Fv+Ahkt12W0wcYO EWVyclcBedesXwLwa10O/+RKuusEKyP3kZVNAGDU8A2A/7UIztvwW6jxqagPWGfzcEBL7/XD j1ox0BelM64WqrJUFz/tUG8UJdBqkVpg9fiHNUKmZ763WrCN+C15bA00nB78a0SAWLQ/QYI/ nezpcEfdcNf5GLLDzogdlFPamlPOOPWdUvCAgajbEZIMM7BZKrQ+DblG67RSKEyUIoQoyh7r k0Fni+HJKPmFNqfMOsMPQosbQpBQKcarU7dWFUqiKja/cCkqD36K+8ts2H71ePfRer/G7F7M 0a0U3n6jdBCKd7Ez92pq7m4s7gs+ZjJuaQOytX2m1sbciqwkx9DZUWFFlipKfY/OL4Vr+v9w 1f7/fC4GMJVkAAA= --------------030009070406030507030000--