Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U3rKm-00041r-55 for pgsql-general@arkaria.postgresql.org; Fri, 08 Feb 2013 17:01:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1U3rKk-0002B9-UY for pgsql-general@arkaria.postgresql.org; Fri, 08 Feb 2013 17:01:54 +0000 Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U3rKi-00029F-8i for pgsql-general@postgresql.org; Fri, 08 Feb 2013 17:01:52 +0000 Received: from mail-ia0-x22c.google.com ([2607:f8b0:4001:c02::22c]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U3rKe-0002XQ-Em for pgsql-general@postgresql.org; Fri, 08 Feb 2013 17:01:50 +0000 Received: by mail-ia0-f172.google.com with SMTP id u8so4472300iag.31 for ; Fri, 08 Feb 2013 09:01:47 -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=O0UgXU/SBMBAXnrUvU0Nzrk55EJatbl95z6xM2BrjwQ=; b=SuTA2rN/sgYD5X2qRVsg3p2FmJ4clYEW71b1Z1JikvjuKS1SQUmFKMc/h/+1y45Pfu dYVVqgV8HaC+KsbRjtkssFT86YZcByDXHIcMewgR9oBH+iV8IH5C/qW1mFdr4+Tod9sy oQi2dxbama12Qc7WCR81509hNS8t5tmpt5IGndKF4ijoxIYcZeKG9dK3wSzfrhB65G6y rYHCFodNlu8TatgnMrJ2RXxVXmUvBK9euS8xFcPUNZKqsudPR/2M6pr8P26lylTxkKKm cNJ0y+isBJRs1joC/dycDt3XG/STp/C6xvVcE5iabO4GUvSX+u+Fq3l86TAAqu0kUBrQ ApCA== X-Received: by 10.50.189.233 with SMTP id gl9mr3584447igc.81.1360342907341; Fri, 08 Feb 2013 09:01:47 -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 vb15sm11421125igb.9.2013.02.08.09.01.45 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Fri, 08 Feb 2013 09:01:46 -0800 (PST) Message-ID: <51152F78.8040506@gmail.com> Date: Fri, 08 Feb 2013 09:01:44 -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> <51151764.4090405@gmail.com> <609013460.25018.1360337038276.JavaMail.open-xchange@ox.ims-firmen.de> <51151BDA.2090101@gmail.com> <1000342202.25103.1360338334505.JavaMail.open-xchange@ox.ims-firmen.de> <51151E5F.70906@gmail.com> <193127308.25154.1360339032141.JavaMail.open-xchange@ox.ims-firmen.de> In-Reply-To: <193127308.25154.1360339032141.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 07:57 AM, Andreas Kretschmer wrote: >> Well I got left is: >> >> REVOKE PUBLIC FROM ak02; >> > > i think you mean: > > 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 > No I was trying to revoke membership in the PUBLIC role for ak02, on the chance that ak02 was picking up privileges from it. I do not know if that is even possible, but at this point I am grasping at straws. -- 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