All users can change their passwords at any time using sp_password. The System Security Officer can use sp_password to change any user’s password. The syntax is:
sp_password caller_passwd, new_passwd [, loginame]
where:
caller_passwd is the password of the login account that is currently executing sp_password.
new_passwd is the new password for the user executing sp_password, or for the user indicated by loginame. For guidelines on choosing and creating secure passwords, see “Choosing and creating a password”.
loginame can be used only by a System Security Officer to change another user’s password.
For example, a user can change his or her own password from “3blindmice” to “2mediumhot” using:
sp_password "3blindmice", "2mediumhot"
These passwords are enclosed in quotes because they begin with numbers.
In the following example, the System Security Officer whose password is “2tomato” changes Victoria’s password to “sesame1”:
sp_password "2tomato", sesame1, victoria
