X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 19CD352B39 for ; Tue, 12 Jul 2005 15:17:25 -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 33799-10 for ; Tue, 12 Jul 2005 18:17:10 +0000 (GMT) Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 87DFC52B52 for ; Tue, 12 Jul 2005 15:16:20 -0300 (ADT) Received: from mailserver.gpmd.co.uk (unknown [217.8.241.55]) by svr2.postgresql.org (Postfix) with ESMTP id 573DAF1C72 for ; Tue, 12 Jul 2005 13:18:39 +0100 (BST) Received: (qmail 18203 invoked by uid 107); 12 Jul 2005 12:21:34 -0000 Received: from unknown (HELO gvickrage) (graham@gpmd.net@84.9.13.245) by mailserver.gpmd.co.uk with SMTP; 12 Jul 2005 12:21:34 -0000 From: "Graham Vickrage" To: Subject: Copy user privileges Date: Tue, 12 Jul 2005 13:21:21 +0100 Message-ID: <013301c586dc$369ad110$0c67a8c0@gvickrage> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.013 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/99 X-Sequence-Number: 22077 Hi All, I have dumped a database with no data and restored it with a new db name. I want to keep all the privileges but assign them to a new user. What is the best way of doing this? Is it to alter the system tables directly in which case which ones. TIA, Graham