Change an user's password that doesn't have sysadmin rights

[Toyman]

Hi
I created a user that only has select rights to tables.
The user must be able to change his/her password. I tried using the sp_password store procedure to do this but it only allow users with sysadmin rights to do so. Is there a way around this.

Thanks
Toyman

 

[rajeevnandanmishra]

Hi Toyman,
If you execute the sp_password with only two passwords user will be able to change there passwords.
like sp_password oldpassword, newpassword

If you still face problem, please let me know with the exact command you are using.

 

[xcata]

Hi,
sp_pasword execute permissions default to the public role for a user changing the password for his or her own login so that user, normally, may change his password.

ex: EXEC sp_password 'oldpass', 'newpass'