From: Joshua D. Drake <jd@commandprompt.com>
To: Bailey, Larry <lbailey@firstam.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to revoke a password
Date: Fri, 08 Jul 2005 17:56:06 -0700
Message-ID: <42CF20A6.8010901@commandprompt.com> (raw)
In-Reply-To: <C45835824D00A844BBD0F032D5CDED9201610766@pisgana01sxch01.ana.firstamdata.com>
References: <C45835824D00A844BBD0F032D5CDED9201610766@pisgana01sxch01.ana.firstamdata.com>
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@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
>
>
>
> ---------------------------(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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, lbailey@firstam.com
Subject: Re: How to revoke a password
In-Reply-To: <42CF20A6.8010901@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox