Change my own password
From SQLZoo
Change my own password.
schema:gisq
Users should be able to change their own passwords. The administrator should be able to change other people's passwords.
WARNING
Many of these commands will work and change the password for the user scott. This will prevent you and other users from using SQLZoo - if you do change it please set the password back by visiting the appropriate fix page.
ALTER USER scott WITH PASSWORD 'tiger'
!passwd
ALTER USER scott WITH PASSWORD 'tiger'
ALTER USER scott WITH PASSWORD 'tiger'
ALTER USER scott PASSWORD 'tiger'
password
sp_password @old='tiger', @new='tiger'
set password for scott@localhost=password('tiger')
ALTER IDENT scott USING 'tiger'
sp_password @old='tiger', @new='tiger'