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.
See the Reference Manual: Procedures for the sp_password syntax.
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
