Thanks but it is still prompting for a password.
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
