changing password for sql server login
-
Hi everyone, I would like to know how an administrator can change the password of a user who has forgotten his or her password. Using sp_password requires the old password before the change can be made. I would be happy to know how to solve this problem. But if it is possible to retrieve the password for a user, that will solve the problem and I will be glad to know how to retrieve a user's password if I am an administrator. Thanks in advance.
-
Hi everyone, I would like to know how an administrator can change the password of a user who has forgotten his or her password. Using sp_password requires the old password before the change can be made. I would be happy to know how to solve this problem. But if it is possible to retrieve the password for a user, that will solve the problem and I will be glad to know how to retrieve a user's password if I am an administrator. Thanks in advance.
-
Unrequited desire is character building. OriginalGriff
-
Thanks. I got it. That was about changing the password. But is there also a way to view users' password? Looks like that was not described there.
I don't know off-hand, but I doubt it. Any system worth its salt will never allow passwords to be displayed, only reset. If you allow the administrator to view a user's password then it is open to hackers; not a good thing.
Unrequited desire is character building. OriginalGriff
-
I don't know off-hand, but I doubt it. Any system worth its salt will never allow passwords to be displayed, only reset. If you allow the administrator to view a user's password then it is open to hackers; not a good thing.
Unrequited desire is character building. OriginalGriff
-
I don't know off-hand, but I doubt it. Any system worth its salt will never allow passwords to be displayed, only reset. If you allow the administrator to view a user's password then it is open to hackers; not a good thing.
Unrequited desire is character building. OriginalGriff
-
Richard MacCutchan wrote:
Any system worth its salt will never allow passwords to be displayed
I see what you did there :-D
Funnily enough this is a perfectly normal English expression (but I guess you know that), and it was only after posting that I noticed the significance of that word.
Unrequited desire is character building. OriginalGriff
-
Funnily enough this is a perfectly normal English expression (but I guess you know that), and it was only after posting that I noticed the significance of that word.
Unrequited desire is character building. OriginalGriff
Give you both a five to counter the 1. Arrrrgh.
-
Give you both a five to counter the 1. Arrrrgh.
Thank ee Jim lad! Some scurvy knaves be cruisin' around these 'ere parts!
Unrequited desire is character building. OriginalGriff