Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E33E9636FFA for ; Sun, 9 Aug 2009 20:07:57 -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 51177-02-4 for ; Sun, 9 Aug 2009 23:07:54 +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 1F0B5635EE5 for ; Sun, 9 Aug 2009 20:07:25 -0300 (ADT) Received: (qmail 18501 invoked from network); 10 Aug 2009 01:07:24 +0200 Received: from unknown (HELO ?10.12.0.96?) (88.103.48.48) by 192.168.1.50 with SMTP; 10 Aug 2009 01:07:24 +0200 Message-ID: <4A7F56A0.5060705@pjmodos.net> Date: Mon, 10 Aug 2009 01:07:12 +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> In-Reply-To: <21542.1249492707@sss.pgh.pa.us> Content-Type: multipart/mixed; boundary="------------030906020400070005020304" 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/726 X-Sequence-Number: 143369 This is a multi-part message in MIME format. --------------030906020400070005020304 Content-Type: text/plain; charset=windows-1250; format=flowed Content-Transfer-Encoding: 7bit Hi, 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). -- Regards Petr Jelinek (PJMODOS) --------------030906020400070005020304 Content-Type: application/x-tar; name="grantonall-20090810.diff.gz" Content-Transfer-Encoding: base64 Content-Disposition: inline; filename="grantonall-20090810.diff.gz" H4sICD9Sf0oAA2dyYW50b25hbGwtMjAwOTA4MTAuZGlmZgDtXHt32ri2/5t+Cp2u3luSuASD eTUzXYuCk3KHAGOTdnrmzmIZI4hvjM3Y0DbT9rvfvSXLlsEQ0mSatnNog209trR/W9oPSXji TKfk2bOZsyTW8cS3j8MA/mZz9zig0+NZYHnLAj6S8a7cR443oR/IeNqolsf1QqFeLk20CiVq sVjVtEeHh4e7qT969uzZDS0cpj9k4IfLWUDNX7sEqq3m1FtaS8f3WGOlslJqECz3iJCfwmvP X4RO+AIezoxmb0g+wj9T7+qtIflEOj1TN/DmYtBuDnW4aUMWuxkaF70WTzP0U93Qey3dZOmd szPdIJ+BIn5+VwqFwh+Q0ex2ye9kYHRed7r6GZT9A8r8i5Xp9yBn2HzZ1SHxp4AuXMum1til xHatMPz58aBpNM+hXePxiyWme9ac/nQsFXwB7RBsKGp12Ac2fgeW+heDm2kGfibJT2Rw8bLb aZHPgjqQfNMZvoqg6g+GHeg6trkvfBJUn0n+pn7Zvruae9mMkgM2MkCc5SKM0mfPvilxfrw/ gXKavEFG0gQ+iNl6pZ83b6Id2pd0bm0nHrP1jxgv63pi3x4wvVGGgRbrjVT3L8zmGZaMiUR1 bzlkTP3XC+T0RpnSP1fUs79xHdAydI5fq9/rcViG+vmgbzSNt9E9I7kLGpzfZU3RVDG//w7Y P94n8PJcFWR/uOl6H6LdNhWFULdVIlpDqVTENHxgKPTf9NbFcGt34yF2CqaF1Zc792K68uyM ruSB0O+ZbCysAIovafD4hRXM5v5kveofe1XMaDMbtnS15fVi26gE3frtqJ6dIwg1SkVVKnWh Ub6TEfTxHzWGZC0q+P7BtOhNei5DOd7cPaYgVa2sqFqdq0gc76pWVdRKIxnxPx2jVF7wDsEj fzpiiFzSgBInJJYb+mR5ScnCD0Nn7LjO8pr4U8KiLsebkQUN5g5k+V5Ilj6Ud4k//j9qL0Mo xonNnHfUIyhz4nihM6HE9+AvIPOVu3QWwAWXVFiAdqFNHMwYplmsMUgIV4uFHyzphNObQlXm LIcKeefQ93ARJhk67E1iAvzJtjwI/6DF8TVZhdBnTgUR/8j96E+xif4UD7PP0jhLBhKBwGJp fQA+CJMBJwV4cJ4JlimwRAHuEeGPAmoObgQnsL4InHeOS2fY9YA+F8IgP72zAgeZdJ1w+eLR ZGcMHtB3/hXdGoRL2VEUXp9US5V6sVDQipX6ZFK9IQqXCWwJw+Uit4vDNQzcIkNu6K/7v+hs Lkpz5rRvEGFRfoyw/NTon/8tOkdwRVpNs9Vsc/ZNYBrwYqqHxcoAeexLf7OQ/+2hc8qC7m0s Hk5069Nql+RYpFpXNO12M+tbDWEfdr6UG4pWvd18+a6C0h99IlRLSrUuLdnsI8L/xHTbYrqH nYtVTanJ60D3Kcv/RFffpTpI+cbolI4t+4p6k2PbWlquPzu2bNe+vCrY4Lfuyo58Y2prljUF 33hSrtfqtJb2jXcS4L7xziLruitEV9gm73xnQvQP1D7DwGrUA2DCBYCS73ggVgiFuCJTlWo1 iejwMV7ByCY0ZHFSihLLIIcsgjOX8+XBCZ9JEYEuxBvkkMczrBtDv+9Mwjyr1mfJQwzloAQO NCWpgNIMgdpRmtSMLmN2Qk4g3IeiFy62UzSoy0KIsOMlWAFVFoGxp85EIfalFZCAulcgWcam DBL9sIDwcGT77igJwvK8BUhkhBSCNJl7OYI6CpDI4QfCR9s9h3kNsbETSvUzShymW1A2hgBK a7WkZ0Ig+fiOHIYoIB4n1atKqVESZixHDo/x4mCJAvSByZP8TPD52QuRcJKUieCNi0TPJ6AI khIscP+ZbIo/VUdJSGAFBm3u+BCjf8YpWwoYUzJ1XJdO4M7130f9hVJSyLu1GO+QQA671Ot0 T3JYfW5dExgBG7VYZFOvQzQZ+2r3ChLiFL53lvYlidBglTH7APM+4lfOtkLKbdFo+Hagj/ov /+c5y7g7xozKOKDW1UlmU6DIR53eiC9abGl062S8ZdsTOrVW7jJqBUQwy+uG0TcU8njlBdT2 Z57zF0iHA440n5P/mjwWhBPkGDm0wd/CEFqfmftqQa6ciw2lqmqSei6VlZoWL7jlArpcBZ5Y HsNBh7aTrxAdH+Iy0eFW+bBcXuQMOp5eZiOWvMY2Dfw5CRfUdqYOMMcNOMFlJOJ4uETnMaWG CWypCvhe06/wfGelDTQ+wl8Ok0EZCosixCCyWhQ4gVwbriwRVTYrH1FiidAyjDJJtZ9w1OL5 GPUCW82xZvnkaLa6OAEhAhsZereJHs5zlpub+jCW7cs8tqsQudeQySnkkr4HwtokvY+KRDWZ vgheW27enTpBuGR0D5jlyqV7DiW7vn+1WugfFq5jOwnM+YjWgURebnib1UtZPGDzl06vHbMr E0skgLIHw+eBd5KPUhUStyW6/ZlfolmfBaqIIv8hoAp2/15QhS9+G1BN2/J+oddt8DbJFb3+ Xf1DoPSKWgvMbdPQBl1geXLGcLVwaW6J3yJZoIEofT2RRP3veM4y/9/IQPEPJcqCT9NbzUeL Gehx38avuBmpzMuh/ufKcs1lYC3p7Lq3mo9poJDTUb/T1n+VCnLd1ZmAGgW4VnNZ1AdrwwSY uASYRv6CevkBtE4nq4AKiHBoNG3Qj6EJSot2fftKro9gCwJjOnM8TMgDVYWYnrUIL/1lz3+v EFVBkck131+CbSP5PBOMIAEj1aMflnmkAnz5wXsrmDDJOmBvsT8HB+RfMJUuut1odMTDQx6l 1gKYmaA3m4zSeCwAKKBrecOJWD8nXWNdgfqMF/yS+80ybdcPKWczC5zMKRB7E0e7vYnYMRZ+ GncqouZJHuzbgbBIvDXR9XXbe0SiXqRtb5YukEyvwakwWwpmN1EkjhdZ4HgwoW8B8RZ6F9dx QYKByC6b+wVhzYahzdCrG/qhxPVDtnLI0gxZamHHpBUzloX9I6izMWX3m6/7TdaNjqjbO4KY 3diH1qumkXSiBXDHHRCwx42vqwmB1D5aYl8VUUqriPvRD1w5yKNF1g1x+m7tIObXdr2wj1KQ Zmjcrpij+J/gHMWxnR20s6zty0AeROHhse0vrnEhL9xYB9rIjxaCSpVGVZ2ohYJVLFn1cnn7 QtAmhc2VoM0y69HGCDMzVwHQpY9WAUr1hlIqNaQwQyRVpFXRXKs/eAuRYLPbNEanHb3bzotg lwfrm/kptbmZLUdson6v39aT2slKwHpmIqnsfEabstwbhEhxvu6SolwgEqOqlSyrPi0UinWq qUD+BjGmSGyTY6rQhiBZbqYkLSUxYmwjgzTqRaVRryTy5AnxGsZHjtj5AFTSbolmFFkTakaJ DbnyMttFu5G/Kd2NIvsIeGEFIQ3wOP+8cL2GeSovEqs1bVjUKoJY1Xq1PK5uF2u69qZE0/lr wuQyqipqMV56Q7TAY0FPeGUvyQD4H1oB6F8hrS0xMlvqkONhvgYgEYhWYvkwwDbLYhTcqU2W h6m5XCzuVGfITR3asmqNNNFPIYdsnfkU5oNI4gupDD2t2lC0WnxYM6f/1upetDu9M8LuzM5r Pd6i0X/rmEMTLoNus9OD61A3es0u3hjN1jDSbqfNrqmPBuS0ed7pviWn+rD1ipx2DHOIid1+ k1373W7/DTaDu0Hw19LxW++csf2hN02jjRicGrr+b51vX5xeSHshUVtn3f5L6ADfXmLfehuu ePTVHPLNjtFACE2rFYHVZP3xO2E12f+5LdN3GhiVYk2pqPFh+hxftHiN7MKt3jR1uPaa53gZ QNvsMAjcdpstfu20mrgXpA/ZjlDTGHIq0eaQoQ8vjB6iwu9MsVlodM5eQXYfqQFyL5utX+Dm Df5BmYuujpwBXmbztT7odwCC6CCY2cLyxNSbBkjB1Fv9Xhs6CzcXRmf4Vuz2i3UC7I2pG51m t/Nv1nd4eK0bcDHNDjsmwa6jC5MlYsVh/5SY6H2yuq+gU2YHBN808DpAEufNbpd1qQ+4mBwT uPTazW6/h9AxIPB7qJ/rPQYJPsBg67RMSG/jwbZhu3+BhfoGnlPggLG6RmeA14uXeAvQmRcD 3cAOMnnnzLfn5zqWJuZbs9PGb2iGjwVAjHeHH7EZoJTYIXD86uLph+R4+BBGObQzfKX3yLAD nOAXdPOctTLsE5gDnS52AG56ZpMP0yGOwPg8EVzP8dCRzrsWHz+CGxPHK1sUj6dmpVhXKqX4 J0I/3GBLjnT8s4fdtzf61nVk7AA+z3EFK+1mQDPxEzeeJa2kwFctcRDhqYxJyc4CW3tL9rMg lAM3gZ5IWVITP5MnJTkr2fLKP9EOpC2vo7hI7DXEhSQ/IkUpWmWKKYVyvnADsQvVjQwIn9ka CWTWTjZAM9j5UoZahEulDiBUyzIu1SImVddxWSM/tdzwOwJnTC+td44f7A1MTQUUalUZmJoG SfXiDcDsHjSVbbjU9sGltg8utRtwaWzDRS1uAhP3frRkvmwET7kCk6dckQ7Gw1MNkqplGZ6P oqXEGSaHCFJeTjggC8t1fTsfOn9RfyrlHRxkw5WxJbUNtPQu8ho5hocaJz55As+eeNz86cA2 MHDGlKsVGYxqBZKSM1bfDRilu4OBw6BWksGo4WCpNb4yGMKUPyQYqDKQcwmMOiiWcr32lcE4 bb/5chy0O+PAma6mcIB4tpyst30tHHhAN+Le3JdDUr47JHXkX7a85QZMHa34tTWoCFsfcp40 Ksh5UQJDK2KS+rU1aBtjFghjHhAMrVhCMGRfVVPLCMbX1qDdZu/sAmKMBwWjgZxrMhglUCbg jX1lMDCqZQHRQ6KhVjnrDI2vxnoSDN6OK7yyxc9nuB4W+aAj3Ph9zstESTnx+UgYCXYIZG5d UTX/RD04IZxS7lOKBHmqPCUSAVGXb79BRQW0NKscjRocSFXtK48aGbr7HzZHHJbUL7JwBYCv feA2L4Nq/SDDHdg92s3uLRzQ1EHLNcIiVDpKs320ybb8E5wH5fwW3ub9cC7/2uBBOb+F/3AH zmNd8oCKZF1L47GakAbv6GR0Ra/f+8GE62m1iEeo4Vt279RiuVTB3aiy7NN84hsN0gPbZxCP YhflKP1sigJ8iyF+4nsM4vFVs9fu6sYtuo0eqFrUiiW52xDZY6KW7rZYSpWe2Ypq8hwt3x+l n82kQLK4KqWBV548sSXWW/RfU1n/S+n+V3ATUKuW0v1Pr42yJFwVlR744mjUf65fRW6i1uMU /Xwg3+Ni6eY+rePZ7mpCo/1vtmfKbguX0Xbq9gLxj84rdrFSLxSKk2qtXsvYsd1BItm23VFo HW6xa0q91Zys7ZBy3NVGWVFLRXmw8yQ1WSzLtInsHPky/nUNP3P+eb0RNu2PMvrBehCd3Eqb UYXIn2O2peZNrECcpffFUTO+cJYPD/hpstw2ZRWRiWuvnR2P3ssQEeWnxWOin5PenvCDOGsb 0fFa9qNoH7oHohhas1wuXucb+76LP0SIfmvBgQtWsX5V+IIsPEY7Jvz4/rYNbayOJ7Ckty6M Kb6Jwl9QPMc1QR4jROJ972TlkTfPCE7Ziy04LrY/nwPM+CYJypKZqKyx/y4S7cZBdk5JHAU0 LG9GX1sBYUNRIbjj+cZZXjaDWRilCU8IPuQQX3+xcC0nOjFI8lZIXlsuoALAAjdcAHKzyWJs umV+ngrNHm8H622dvNFRh6v37PT/+sxdy42mbbVGG/ZYKxRg/k4mDXv7tF2vvzln10usT9jB 2egX/e2bvtHOP54GlP5FHwOWbNta4TsqaEdGPT55qzBRq/IbTlhCHGqmiflzRqp/rrBdPNDW bZF9sF545bpY+KLbTbUKYdT2KvyVI6wat3QKuehttnSUWS2U6pnZFdPtzVx/bGEnuRndqwoO dKzBJ91exelEVNDb2W3skmBIbd9DCsLiSiSYBMululIuS8q3DKFOuVzJkiAQWwXO8pqTYwZ7 H65D6sJsZZVwu/RmvsUP6VkVbvj3kWT8Bhqp3l6ShPngWK7zF5oSVjfxLfas/o4GvCI4IPtV Ye/rYXWYm/IFkr2ezykoKhuJiL3ZCFsuWfBcylVVkmwFRJ3EsGliocNGCToxezFwHS7pnNdg ns4+lZYRwEOO7E3y5KZdlN9Lkok3EFdDT2GvqnS+wErgfe1b3AVbF1VBhy272oYhWNJweRzQ Gbih4TH9sIC5QSfHiW0p+KtlpLP3KSo8u2JjXK1UwUQ0apXptLhpIvYiltiLvYqvD9DoQMSl FY74L3bj8vmnEa0VTBeVdauuVpR6SVq2ZQnJnjpBjyavksB/f8CdOChztsWHSr3hiliRFwV1 +HkRcfCieTF81TdgbouYM3J4MCbG7KwXuy5WY9ex+ZktmQmsvi/DTxXy1EJI2R2v9RTCQuCI uV74i4QMIoznjA8Wx1d7CXTYGe1NVrLe2Labmy1IbeMbOUIDWspXBDOOC9nspyPPifRqMjKh Hv4WEt8cJkxuUv1mOfFjGnuIadi/u5BKG0JCb/kLZLRcl9EGGztElMnJXQXkX7F+ScCvdTn6 qJV01wlWRu6FlU0AYNTwFwD/axOct9FLSeNTUR+wzubhgLbRH0Rvl2KgL0onXC1UVaUuv2Oh 3igqoNWEWmD1+BsuIqZngb9asI34LXlsDTSaHvy1QICY2J8g4Z9u9nS4o26463yM2GFnxPbK KW3NKWec+k4peMBA1u0ISYYZ2CwVWZ+GWqN1WikUJloRQhTtBuuTQWeL4cko+YU2p8w6ww9C yxtCkFApxqtTt1YVWqIqNl81KSsPfor7y2zYzerx7qP1fo3ZvZijWym8m43SXijexc7cq6m5 u7G4L/iYybilDcjW9plaG3MrqpYcQ2dHhTVVqWj1G3R+KVrT/4er9v8HM1rI9R5kAAA= --------------030906020400070005020304--