Thanks but it is still prompting for a password.
Larry Bailey Sr. Oracle DBA First American Real Estate Solution (714) 701-3347 [EMAIL PROTECTED] -----Original Message----- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] 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 > [EMAIL PROTECTED] > ********************************************************************** > 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
