Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U3pjL-0003Dr-K5 for pgsql-general@arkaria.postgresql.org; Fri, 08 Feb 2013 15:19:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1U3pjK-0003Wa-FA for pgsql-general@arkaria.postgresql.org; Fri, 08 Feb 2013 15:19:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U3pjJ-0003WV-Fi for pgsql-general@postgresql.org; Fri, 08 Feb 2013 15:19:09 +0000 Received: from ia-in-x022e.1e100.net ([2607:f8b0:4001:c02::22e] helo=mail-ia0-x22e.google.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U3pjH-0000Sr-Fx for pgsql-general@postgresql.org; Fri, 08 Feb 2013 15:19:09 +0000 Received: by mail-ia0-f174.google.com with SMTP id o25so4230399iad.19 for ; Fri, 08 Feb 2013 07:19:04 -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=41GqfFh5AV/OWDpKaHJooIA3W547aV2bE/RkjfUOVcs=; b=W0zyZrg40RbO7ZYQ0C8q4S/QYuuJ2hbWHSrMetHlF3Mpr0g3Z/j/lThsdaFpA1WFBK sbLbakx+VPDubF8HbGpcnOr+y1ktO2S6Amj2KUOOzyGGDWf3/m7+j3HXvfoVNEz55r3p c70DXZu2mrkXZH6BoAusN+WBtssEO0KvBFUDqAZGlZUT42niofHZ0/JgtTMne2rO6yRD 4zn+g22ii6xrl3uv9TJQZTLjGFwlNQ/GRFBnOxr6RhE4mVs4XDQYbjXJDP86y2RgK+oP XkSBs2PCI7YPeDqbLvGRC2cmfG3NenThwTcz2wkl9LEBOZxMQYzEfmxgZ3cFjjnHjFz5 TNIw== X-Received: by 10.50.40.131 with SMTP id x3mr3102806igk.10.1360336744091; Fri, 08 Feb 2013 07:19:04 -0800 (PST) Received: from [192.168.0.2] (c-24-17-164-54.hsd1.wa.comcast.net. [24.17.164.54]) by mx.google.com with ESMTPS id kf2sm15499403igc.0.2013.02.08.07.19.01 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Fri, 08 Feb 2013 07:19:02 -0800 (PST) Message-ID: <51151764.4090405@gmail.com> Date: Fri, 08 Feb 2013 07:19:00 -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: Andreas Kretschmer CC: "pgsql-general@postgresql.org" Subject: Re: 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> In-Reply-To: <1568445490.24920.1360335539088.JavaMail.open-xchange@ox.ims-firmen.de> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org On 02/08/2013 06:58 AM, Andreas Kretschmer wrote: > >>> How can i drop a user as SUPERUSER (!) with all privileges? >> >> I believe you will need to REVOKE ALL ON SCHEMA public FROM ak02. > > > doesn't help: > > -bash-4.1$ psql -U postgres db115150 > psql (9.1.8) > Type "help" for help. > > db115150=# begin; > BEGIN > db115150=# revoke all on schema public from ak02; > REVOKE > db115150=# drop user ak02; > FEHLER: kann Rolle »ak02« nicht löschen, weil andere Objekte davon abhängen > DETAIL: Privilegien für Schema public > db115150=# > > So what does \dn+ public show? -- Adrian Klaver adrian.klaver@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general