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 252AE52A00 for ; Tue, 16 Aug 2005 21:00:47 -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 47404-07 for ; Wed, 17 Aug 2005 00:00:39 +0000 (GMT) Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net [194.217.242.92]) by svr1.postgresql.org (Postfix) with ESMTP id 31F5B529E8 for ; Tue, 16 Aug 2005 21:00:38 -0300 (ADT) Received: from lfix.demon.co.uk ([80.177.205.209] helo=cerberus.lfix.co.uk) by anchor-post-34.mail.demon.net with esmtp (Exim 4.42) id 1E5BMH-0008B9-DW; Wed, 17 Aug 2005 00:00:41 +0000 Received: from linda.lfix.co.uk ([192.168.1.1]) by cerberus.lfix.co.uk with esmtp (Exim 4.50) id 1E5BM9-0001EF-Bb; Wed, 17 Aug 2005 01:00:33 +0100 Subject: Re: GRANT ALL PRIVILEGES ON DATABASE From: Oliver Elphick Reply-To: olly@lfix.co.uk To: Andrew Gold Cc: pgsql-admin@postgresql.org In-Reply-To: <430271C8.8030909@cbamedia.com> References: <430271C8.8030909@cbamedia.com> Content-Type: text/plain Organization: LFIX Limited Date: Wed, 17 Aug 2005 01:00:33 +0100 Message-Id: <1124236833.12095.101.camel@linda> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 Content-Transfer-Encoding: 7bit X-LFIX-MailScanner: Found to be clean X-LFIX-MailScanner-SpamCheck: not spam, SpamAssassin (score=-5.899, required 5, autolearn=not spam, ALL_TRUSTED -3.30, BAYES_00 -2.60) X-LFIX-MailScanner-From: olly@lfix.co.uk X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.053 required=5 tests=[AWL=0.003, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/207 X-Sequence-Number: 18526 On Tue, 2005-08-16 at 16:07 -0700, Andrew Gold wrote: > Obviously, I can write a script to iterate through all the tables, but > what exactly does "GRANT ALL PRIVILEGES ON DATABASE XXX" do if it > doesn't even grant basic access? See the man page for GRANT. It gives the right to create schemas and temporary tables in the database. -- Oliver Elphick olly@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== Do you want to know God? http://www.lfix.co.uk/knowing_god.html