* Joshua D. Drake (jd@commandprompt.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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 4 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedMar 24, '06 at 5:58p
activeMar 24, '06 at 7:12p
posts4
users3
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase