X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6E794528FC; Tue, 9 Aug 2005 01:44:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88574-10; Tue, 9 Aug 2005 04:43:55 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 2B3FF528C1; Tue, 9 Aug 2005 01:43:55 -0300 (ADT) Received: from [192.168.1.101] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.13.4/8.13.4) with ESMTP id j794gtnN029032; Mon, 8 Aug 2005 21:42:55 -0700 Message-ID: <42F834F6.2090908@commandprompt.com> Date: Mon, 08 Aug 2005 21:45:42 -0700 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 1.0.5 (Windows/20050711) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Marc G. Fournier" Cc: pgsql-admin@postgresql.org Subject: Re: REVOKE from all tables ... References: <20050809004545.S958@hub.org> In-Reply-To: <20050809004545.S958@hub.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (hosting.commandprompt.com [192.168.1.101]); Mon, 08 Aug 2005 21:42:56 -0700 (PDT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200508/98 X-Sequence-Number: 18417 Marc G. Fournier wrote: > > Is there a way of REVOKEing privileges on all tables in a database? > I've checked the REVOKE man page, and there doesn't appear to be, but > I figured I'd double check to make sure ... No. This has actually been a requested feature on the grant side as well... Nothing a simple for loop can't do with perl though. > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match