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 A8D7352BC2 for ; Wed, 17 Aug 2005 12:53:14 -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 33369-05 for ; Wed, 17 Aug 2005 15:53:10 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id C28F4529C3 for ; Wed, 17 Aug 2005 12:53:08 -0300 (ADT) Received: (qmail 28138 invoked by uid 500); 17 Aug 2005 15:54:55 -0000 Date: Wed, 17 Aug 2005 10:54:55 -0500 From: Bruno Wolff III To: Zuoxin.Wang@kp.org Cc: olly@lfix.co.uk, agold@cbamedia.com, pgsql-admin@postgresql.org Subject: Re: GRANT ALL PRIVILEGES ON DATABASE Message-ID: <20050817155455.GA28113@wolff.to> Mail-Followup-To: Bruno Wolff III , Zuoxin.Wang@kp.org, olly@lfix.co.uk, agold@cbamedia.com, pgsql-admin@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/225 X-Sequence-Number: 18544 On Wed, Aug 17, 2005 at 08:14:02 -0700, Zuoxin.Wang@kp.org wrote: > Could you tell us what is the best way to grant a user who can select all > data from all tables, if I don't like to write a script which Andrew > memtioned earlier. Other than some kind of script, you can make them a superuser. That may not work for you though.