sqlpro:atleast in this case, if all passwords are reset , how its going to re-authenticate before allowing new password?
freitasm:kenkeniff:muppet: I'm curious - from a technical point of view, what did you do to the database to reset everyone's password?freitasm:
Technically? I was going to update one password but instead typed the command and pressed the EXEC button before finishing up the WHERE clause. That's not very technical...
I think he was asking did you;
a) NULL everyone's password so no-one should be able to log on?
b) Replace everyone's password with an identical HASH, in which case everyone could log on with the same password (if they knew what it was)?
or c) Replace everyone's password with a plain-text string (in which case you're storing plain-text passwords)?
a) NULL password
As for c) if I had stored a plain-text string then no one would be able to login either since the password is hashed and the likelihood of an English word matching a hash is pretty low...
<- don't ask me where I am - I haven't a clue: its a tech thing ;)
Housewife computerer: not particularly great at either.
And don't take me too seriously.
Procrastination eventually pays off.
Cloudy: Mine seems to still be working, just selected from my bookmarks and I'm in.
plambrechtsen: Pffft 70k. I've so got you beat on numbers and customer impact. No dramas though since it is very minor for most folks on here.... My case... Not so much.
Aaroona: Lets call it "security awareness day" instead off "oops I flicked the wrong switch!" :p everyone should change their passwords sometime!