Re: How to revoke a password

Thanks but it is still prompting for a password.

Larry Bailey
Sr. Oracle DBA
First American Real Estate Solution
(714) 701-3347
lbailey(at)firstam(dot)com
-----Original Message-----
From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com]
Sent: Friday, July 08, 2005 5:10 PM
To: Bailey, Larry
Cc: pgsql-performance(at)postgresql(dot)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(at)firstam(dot)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