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 2C96152A4D for ; Sun, 27 Mar 2005 16:33:54 +0100 (BST) 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 42437-09 for ; Sun, 27 Mar 2005 15:33:49 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 6D1D7535F7 for ; Sun, 27 Mar 2005 16:33:48 +0100 (BST) Received: (qmail 9834 invoked by uid 500); 27 Mar 2005 15:50:26 -0000 Date: Sun, 27 Mar 2005 09:50:26 -0600 From: Bruno Wolff III To: =?iso-8859-1?Q?Dr=2E_Roger_Wie=DFner?= Cc: pgsql-admin@postgresql.org Subject: Re: PostgreSQL: =?iso-8859-1?Q?=B4GRANT_AL?= Message-ID: <20050327155026.GC9280@wolff.to> Mail-Followup-To: Bruno Wolff III , =?iso-8859-1?Q?Dr=2E_Roger_Wie=DFner?= , pgsql-admin@postgresql.org References: <3adfp7F663u81U1@individual.net> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <3adfp7F663u81U1@individual.net> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.01 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/444 X-Sequence-Number: 16942 On Wed, Mar 23, 2005 at 16:20:03 +0100, "Dr. Roger Wießner" wrote: > Hallo! > > Is there a way to ´GRANT ALL TO PUBLIC´? > (All tables, sequences and indexes at once?) You can write a script to do it. I believe examples have posted previously and are in the archives. > Or: Can one map all users to user ´postgres´? You can use groups to do something like this.