Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U3sSE-0000pV-KG for pgsql-hackers@arkaria.postgresql.org; Fri, 08 Feb 2013 18:13:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1U3sSD-0006Kf-UM for pgsql-hackers@arkaria.postgresql.org; Fri, 08 Feb 2013 18:13:41 +0000 Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U3sSD-0006Ka-3i for pgsql-hackers@postgresql.org; Fri, 08 Feb 2013 18:13:41 +0000 Received: from ie-in-x022f.1e100.net ([2607:f8b0:4001:c03::22f] helo=mail-ie0-x22f.google.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U3sSB-0003ks-2o for pgsql-hackers@postgresql.org; Fri, 08 Feb 2013 18:13:40 +0000 Received: by mail-ie0-f175.google.com with SMTP id c12so5297098ieb.6 for ; Fri, 08 Feb 2013 10:13:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=x-received:message-id:date:from:user-agent:mime-version:to:cc :subject:references:in-reply-to:content-type :content-transfer-encoding; bh=vjo7U+2GimNcolNGfPiWcG/eZFb0qoFIv7HbRXZhRcM=; b=NKrouJXIf5u0ryBrftqobq20uMkiLkOL8F0CcopnBsX+ApJAWi02KqkFjOtWiG1L4W yThBBWJtJ+9rk7caB6ulY2rSV8Xw/GyYSNIb2C6ewnXPH9Z9PvMKhODRdskk7C/cUkZu MzPRwlIIp+ZMPRhb3+/cwA5Qvf9y9IYRsjbdQmPjM9rYu03Buf48BL9X5h9tcvJ1b6gR DkmaXbl7/oX44+6/VXJs3Mv6adYddRW9FM8e2+tb+K6xuD/EU4xSmGgkFHP90X+GB9v3 c2gi/41QfQbAcM7rz7FhT+XSn5MKbv2A4f0CJkwOLQrA/+67/3cp/Xk0nSkeygw2hg8G Z/vw== X-Received: by 10.43.134.8 with SMTP id ia8mr10338974icc.42.1360347217865; Fri, 08 Feb 2013 10:13:37 -0800 (PST) Received: from [192.168.0.136] (c-24-17-179-185.hsd1.wa.comcast.net. [24.17.179.185]) by mx.google.com with ESMTPS id iw5sm15120109igc.5.2013.02.08.10.13.35 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Fri, 08 Feb 2013 10:13:37 -0800 (PST) Message-ID: <5115404E.7080403@gmail.com> Date: Fri, 08 Feb 2013 10:13:34 -0800 From: Adrian Klaver User-Agent: Mozilla/5.0 (X11; Linux i686; rv:17.0) Gecko/20130107 Thunderbird/17.0.2 MIME-Version: 1.0 To: Tom Lane CC: Andreas Kretschmer , Alvaro Herrera , pgsql-hackers@postgreSQL.org Subject: Re: DROP OWNED BY fails to drop privileges granted by non-owners (was Re: [GENERAL] Bug, Feature, or what else?) References: <119745304.24731.1360333559327.JavaMail.open-xchange@ox.ims-firmen.de> <51151128.8040807@gmail.com> <1568445490.24920.1360335539088.JavaMail.open-xchange@ox.ims-firmen.de> <51151764.4090405@gmail.com> <609013460.25018.1360337038276.JavaMail.open-xchange@ox.ims-firmen.de> <17143.1360340065@sss.pgh.pa.us> <51152A28.4060303@gmail.com> <19080.1360343369@sss.pgh.pa.us> <51153B61.5010207@gmail.com> <29845.1360346947@sss.pgh.pa.us> In-Reply-To: <29845.1360346947@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 02/08/2013 10:09 AM, Tom Lane wrote: > Adrian Klaver writes: >> I am not sure I am following. Are we talking two different cases here? > > What I was pointing out was that the non-superuser case seems to be > broken almost completely, whereas the superuser case is only broken > if the object owner has given away some grant options and those have > been exercised. Got it, thanks. > > regards, tom lane > -- Adrian Klaver adrian.klaver@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers