Re: [HACKERS] Removing a user's password - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: [HACKERS] Removing a user's password
Date
Msg-id 200306061514.h56FEtN19007@candle.pha.pa.us
Whole thread Raw
List pgsql-patches
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Here is a patch to allow users to remove their passwords.
>
> Uh ... why should a user be able to remove their password (as opposed to
> changing it to something else)?  I'm having a difficult time visualizing
> a use for this.  Seems more like a way to create extra work for DBAs,
> putting back passwords for people who stupidly removed theirs.

Well, they are not actually removing it, just setting it to NULL, as
though a password was never assigned.  We have a way for users to set
it, but no way for them to remove it.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Sequence usage patch
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Removing a user's password