X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E06D152B00 for ; Fri, 8 Jul 2005 21:09:50 -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 12985-01 for ; Sat, 9 Jul 2005 00:09:48 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 9477952B09 for ; Fri, 8 Jul 2005 21:09:48 -0300 (ADT) Received: from [192.168.1.100] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j6909loQ001117; Fri, 8 Jul 2005 17:09:51 -0700 Message-ID: <42CF15CC.9040203@commandprompt.com> Date: Fri, 08 Jul 2005 17:09:48 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050404) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Bailey, Larry" Cc: pgsql-performance@postgresql.org Subject: Re: How to revoke a password References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.025 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/96 X-Sequence-Number: 13337 Bailey, Larry wrote: > I created a user with a password. That newly created user now have > tables and indexes. I want to ALTER that user to exclude the password. > How is this accomplished without dropping and recreating the users? Never tried to go backwards before but: alter user foo with encrypted password ''; But as I look at pg_shadow there is still a hash... You could do: update pg_shadow set passwd = '' where usename = 'foo'; Sincerely, Joshua D. Drake > > Larry Bailey > Sr. Oracle DBA > First American Real Estate Solution > (714) 701-3347 > lbailey@firstam.com > ********************************************************************** > This message contains confidential information intended only for the > use of the addressee(s) named above and may contain information that > is legally privileged. If you are not the addressee, or the person > responsible for delivering it to the addressee, you are hereby > notified that reading, disseminating, distributing or copying this > message is strictly prohibited. If you have received this message by > mistake, please immediately notify us by replying to the message and > delete the original message immediately thereafter. > > Thank you. FADLD Tag > ********************************************************************** > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend -- Your PostgreSQL solutions provider, Command Prompt, Inc. 24x7 support - 1.800.492.2240, programming, and consulting Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit http://www.commandprompt.com / http://www.postgresql.org