Changes a user’s password.
Parameter |
Description |
---|---|
caller_password |
Your password. When you are changing your own password, this is your old password. When a user with the CHANGE PASSWORD system privielge is changing another user’s password, caller_password is the of the user making the change. |
new_password |
New password for the user, or for loginname. |
user_name |
Login name of the user whose password is being changed by by another user with CHANGE PASSWORD system privilege. Do not specify user_name when changing your own password. |
A user password is an identifier. Any user can change his or her own password using sp_iqpassword. The CHANGE PASSWORD system privilege is required to change the password of any existing user.
Identifiers have a maximum length of 128 bytes. They must be enclosed in double quotes or square brackets if any of these conditions are true:
The identifier contains spaces.
The first character of the identifier is not an alphabetic character (as defined below).
The identifier contains a reserved word.
The identifier contains characters other than alphabetic characters and digits.
Alphabetic characters include the alphabet, as well as the underscore character (_), at sign (@), number sign (#), and dollar sign ($). The database collation sequence dictates which characters are considered alphabetic or digit characters.