X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9DDC8D1D18D for ; Tue, 3 Feb 2004 13:54:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 26161-08 for ; Tue, 3 Feb 2004 09:54:47 -0400 (AST) Received: from secure.icanx.com (secure.icanx.com [64.246.58.55]) by svr1.postgresql.org (Postfix) with ESMTP id E1C88D1C9FB for ; Tue, 3 Feb 2004 09:54:44 -0400 (AST) Received: from 63-229-201-197.mpls.qwest.net ([63.229.201.197] helo=[192.168.2.102]) by secure.icanx.com with esmtp (Exim 4.24) id 1Ao10l-0000eX-Vf for pgsql-admin@postgresql.org; Tue, 03 Feb 2004 08:54:44 -0500 Mime-Version: 1.0 (Apple Message framework v612) Content-Transfer-Encoding: 7bit Message-Id: <83A6F4CE-5650-11D8-9324-000A9579AF50@indeq.com> Content-Type: text/plain; charset=US-ASCII; format=flowed To: pgsql-admin@postgresql.org From: Mark Lubratt Subject: pg_dump privileges Date: Tue, 3 Feb 2004 07:54:41 -0600 X-Mailer: Apple Mail (2.612) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - secure.icanx.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - indeq.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/23 X-Sequence-Number: 12197 Hello, I'll get right to the point. I'd like to create a user for my pg_dump backup process. I'd like that user to have only the privileges required to run pg_dump. I have a language, a function and sequences, views and tables in my schema. What privileges are needed for pg_dump to run in addition to USAGE (for the language), EXECUTE (for the function) and SELECT (tables, views and sequences)? Thanks! Mark