Skip site navigation (1) Skip section navigation (2)

Re: Known but bad behavior with alter user?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Known but bad behavior with alter user?
Date: 2006-03-24 18:02:27
Message-ID: 20060324180227.GI4474@ns.snowman.net (view raw or flat)
Thread:
Lists: pgsql-hackers
* Joshua D. Drake (jd(at)commandprompt(dot)com) wrote:
> template1=# alter user foo rename to bar;
> NOTICE:  MD5 password cleared because of role rename
> NOTICE:  MD5 password cleared because of role rename
> ALTER ROLE
> template1=#
> 
> Now we have to reset the password.. which seems an extra
> step that shouldn't be required.

Wouldn't this be because the username is used as the salt for MD5 and so
there's no way to update the password because the system doesn't know
the original password?

	Enjoy,

		Stephen

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-03-24 18:13:29
Subject: Re: Known but bad behavior with alter user?
Previous:From: Stephen FrostDate: 2006-03-24 18:01:04
Subject: Re: Role incompatibilities

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group