Thanks but it is still prompting for a password. 

Larry Bailey
Sr. Oracle DBA
First American Real Estate Solution
(714) 701-3347
-----Original Message-----
From: Joshua D. Drake [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 08, 2005 5:10 PM
To: Bailey, Larry
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';


Joshua D. Drake

> Larry Bailey
> Sr. Oracle DBA
> First American Real Estate Solution
> (714) 701-3347
> **********************************************************************
> 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 /

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to