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 805F9529CA; Tue, 9 Aug 2005 02:20:20 -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 84020-03; Tue, 9 Aug 2005 05:20:18 +0000 (GMT) Received: from hub.org (hub.org [200.46.204.220]) by svr1.postgresql.org (Postfix) with ESMTP id 0E3F8529AE; Tue, 9 Aug 2005 02:20:18 -0300 (ADT) Received: from localhost (unknown [200.46.204.144]) by hub.org (Postfix) with ESMTP id B2D28A248F2; Tue, 9 Aug 2005 02:20:17 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72519-04; Tue, 9 Aug 2005 05:20:16 +0000 (GMT) Received: from ganymede.hub.org (blk-222-82-85.eastlink.ca [24.222.82.85]) by hub.org (Postfix) with ESMTP id E8E13A2486B; Tue, 9 Aug 2005 02:20:15 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id 31AEC49C57; Tue, 9 Aug 2005 02:20:17 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 2D2D149C56; Tue, 9 Aug 2005 02:20:17 -0300 (ADT) Date: Tue, 9 Aug 2005 02:20:17 -0300 (ADT) From: "Marc G. Fournier" X-X-Sender: scrappy@ganymede.hub.org To: "Joshua D. Drake" Cc: "Marc G. Fournier" , pgsql-admin@postgresql.org Subject: Re: REVOKE from all tables ... In-Reply-To: <42F834F6.2090908@commandprompt.com> Message-ID: <20050809021939.J1002@ganymede.hub.org> References: <20050809004545.S958@hub.org> <42F834F6.2090908@commandprompt.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.242 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200508/99 X-Sequence-Number: 18418 On Mon, 8 Aug 2005, Joshua D. Drake wrote: > 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. Ya, that is what I did, it just seemed that there should be a much simplier way of doing it :( Ah well, at least I wasn't re-creating the wheel on this one :) ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664