X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 316A08BA090 for ; Mon, 31 Jan 2005 21:31:22 +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 59713-07 for ; Mon, 31 Jan 2005 21:31:11 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 0B2618BA080 for ; Mon, 31 Jan 2005 21:31:12 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j0VLVApm004384; Mon, 31 Jan 2005 16:31:10 -0500 (EST) To: maillist@shauny.de Cc: Peter Eisentraut , pgsql-docs@postgresql.org Subject: Re: doc change request (7.4.6, reference section, grant) In-reply-to: References: <200501312116.11783.peter_e@gmx.net> Comments: In-reply-to Ralph Graulich message dated "Mon, 31 Jan 2005 21:29:32 +0100" Date: Mon, 31 Jan 2005 16:31:10 -0500 Message-ID: <4383.1107207070@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/72 X-Sequence-Number: 2831 Ralph Graulich writes: > The way the question occured while creating a user allowed to pg_dump > certain databases, but not allowed to do anything else. That way I only > granted SELECT privileges on the tables to that user, but that didn't > work, as pg_dump wants to lock the table. Huh? pg_dump only takes ACCESS SHARE lock, which requires only SELECT privileges. regards, tom lane