change user password in secured database

[tizwaz]

I am trying to change a user's password in a secured database. I am the administrator so I logged into it and selected the user on the Users and Groups section. Then I went to the change logon password tab but it has my name above the change password field. There doesn't seem to be a way to change this. Does anyone know what I'm doing wrong

 

[JerryKlmns]

Log on as the user whose password you want to change

 

[tizwaz]

thanks that works but what if the person had forgotten their password and I as administrator had to change it?

 

[JerryKlmns]

As an administrator you DON 'T know his password, you just clear it and let him change it on his own!

It is his password, isn 't it?

 

[PHV]

Have a look at the ALTER USER SQL instruction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tizwaz]

Oh I see - I thought the administrator had to change it. Thats fine then I can clear it and let him change it.