Message-ID: <42CF20A6.8010901@commandprompt.com>
Date: Fri, 08 Jul 2005 17:56:06 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050404)
MIME-Version: 1.0
To: "Bailey, Larry" <lbailey@firstam.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to revoke a password
References: 
 <C45835824D00A844BBD0F032D5CDED9201610766@pisgana01sxch01.ana.firstamdata.com>
In-Reply-To: 
 <C45835824D00A844BBD0F032D5CDED9201610766@pisgana01sxch01.ana.firstamdata.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Bailey, Larry wrote:
> Thanks but it is still prompting for a password. 
> 

Does your pg_hba.conf require a password?

Sincerely,

Joshua D. Drake


> 
> Larry Bailey
> Sr. Oracle DBA
> First American Real Estate Solution
> (714) 701-3347
> lbailey@firstam.com 
> -----Original Message-----
> From: Joshua D. Drake [mailto:jd@commandprompt.com] 
> Sent: Friday, July 08, 2005 5:10 PM
> To: Bailey, Larry
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] How to revoke a password
> 
> 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
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings


-- 
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