Re: How to revoke a password

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