Re: [GENERAL] role passwords and md5()

2007-04-13 Thread Ben Trewern
I thought I read this be for I sent it. :-( What I meant to say was: Does the password hash change (and how?) Or is the original username kept somewhere is the system tables? Regards, Ben "Ben Trewern" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > How does this work when you r

Re: [GENERAL] role passwords and md5()

2007-04-13 Thread Ben Trewern
How does this work when you rename a role? Does the is the password hash changed (and how?) or is the original username kept somewhere in the system tables? Regards, Ben "Andrew Kroeger" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Lutz Broedel wrote: >> Dear list, >> >> I a

Re: [GENERAL] role passwords and md5()

2007-04-13 Thread Ben Trewern
Looks like the password gets cleared when you rename a role. Regards, Ben "Ben Trewern" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >I thought I read this be for I sent it. :-( > > What I meant to say was: > Does the password hash change (and how?) Or is the original username kep

Re: [GENERAL] role passwords and md5()

2007-04-12 Thread Andrew Kroeger
Lutz Broedel wrote: > Dear list, > > I am trying to verify the password given by a user against the system > catalog. Since I need the password hash later on, I can not just use the > authentication mechanism for verification, but need to do this in SQL > statements. > Unfortunately, even if I set

[GENERAL] role passwords and md5()

2007-04-12 Thread Lutz Broedel
Dear list, I am trying to verify the password given by a user against the system catalog. Since I need the password hash later on, I can not just use the authentication mechanism for verification, but need to do this in SQL statements. Unfortunately, even if I set passwords to use MD5 encrypti