Received: from smtp-out1.bellatlantic.net (smtp-out1.bellatlantic.net [199.45.39.156]) by hub.org (8.9.1/8.9.1) with ESMTP id TAA06928 for ; Mon, 28 Dec 1998 19:03:26 -0500 (EST) (envelope-from daybee@bellatlantic.net) Received: from daveh (client-151-196-125-211.bellatlantic.net [151.196.125.211]) by smtp-out1.bellatlantic.net (8.9.1/8.9.1) with SMTP id TAA09741; Mon, 28 Dec 1998 19:03:19 -0500 (EST) Message-ID: <002701be32be$a782e120$d37dc497@daveh> From: "David Hartwig" To: "Bill Brandt" , Subject: Re: [SQL] change username Date: Mon, 28 Dec 1998 19:03:22 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.0810.800 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800 Pg_user is a view. Non-updatable I might add. Pg_shadow is the table you want. ----- Original Message ----- From: Bill Brandt To: Sent: Monday, December 28, 1998 1:15 PM Subject: [SQL] change username >I have a user on my system whose username has recently changed. The user >owns and is a non-owning user of multiple database. I have tried a command >of the form: > >update pg_user set usename='newname' where usesysid=###; > >When I try this I get an error. Does anyone know how to change this >information? If I delete the user and recreate the user with the same uid >does that retain all the existing database permissions? > >-- >Bill Brandt >brandtwr@draaw.net http://www.draaw.net/ >