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 0CF073A5ABA for ; Tue, 11 Jan 2005 21:05:02 +0000 (GMT) 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 80111-09 for ; Tue, 11 Jan 2005 21:04:52 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 888CC3A5A2B for ; Tue, 11 Jan 2005 21:04:53 +0000 (GMT) Received: (qmail 21255 invoked by uid 500); 11 Jan 2005 21:18:39 -0000 Date: Tue, 11 Jan 2005 15:18:39 -0600 From: Bruno Wolff III To: Tad Marko Cc: Michael Fuhr , pgsql-admin@postgresql.org Subject: Re: Limiting user privileges Message-ID: <20050111211839.GC19876@wolff.to> Mail-Followup-To: Tad Marko , Michael Fuhr , pgsql-admin@postgresql.org References: <1105377550.11245.0.camel@boojiboy.metrosplash.com> <20050110183111.GA2279@winnie.fuhr.org> <1105475175.8275.7.camel@boojiboy.metrosplash.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1105475175.8275.7.camel@boojiboy.metrosplash.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/70 X-Sequence-Number: 15929 On Tue, Jan 11, 2005 at 14:26:15 -0600, Tad Marko wrote: > > I can > > GRANT ALL ON a_specific_table TO user > > but I can't figure out how to simply give some privilege to a user on > all tables. You can't do it with a single GRANT statement. You need to write a script or function to do it.