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:09:48 -0700
Message-ID: <42CF15CC.9040203@commandprompt.com> (raw)
In-Reply-To: <C45835824D00A844BBD0F032D5CDED9201610765@pisgana01sxch01.ana.firstamdata.com>
References: <C45835824D00A844BBD0F032D5CDED9201610765@pisgana01sxch01.ana.firstamdata.com>
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
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: <42CF15CC.9040203@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