Changes a user’s password.
None to set your own password; DBA or PERMS ADMIN authority required to set other users’ passwords.
Parameter |
Description |
|---|---|
caller_password |
Your password. When you are changing your own password, this is your old password. When the DBA or PERMS ADMIN is changing another user’s password, caller_password is the DBA or PERMS ADMIN password. |
new_password |
New password for the user, or for loginname. |
user_name |
Login name of the user whose password is being changed by the DBA or PERMS ADMIN. 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 DBA or PERMS ADMIN authority can change the password of any existing user.
The preferred way to create a user is by using the CREATE USER statement.
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.