Adds or changes a password for an Adaptive Server login account.
sp_password caller_passwd, new_passwd [, loginame, @immediate]
is your password. When you are changing your own password, this is your old password. When a System Security Officer is using sp_password to change another user’s password, caller_passwd is the System Security Officer’s password.
is the new password for the user, or for loginame. It must be at least 6 bytes long. Enclose passwords that include characters besides A-Z, a-z, or 0-9 in quotation marks. Also enclose passwords that begin with 0-9 in quotes.
the login name of the user whose account password is being changed by the System Security Officer.
specifies whether a password immediately takes effect on users who are logged in. The values are:
0 – users who are logged in keep their old passwords until they reconnect
1 – the password changes immediately in the syslogins table, and users who are logged in get their passwords updated while they are still logged in.
Changes your password from password from “3blindmice” to “2mediumhot.” (Enclose the passwords in quotes because they begin with numerals.):
sp_password "3blindmice", "2mediumhot"
A System Security Officer whose password is “2tomato” has changed Victoria’s password to “sesame1”:
sp_password "2tomato", sesame1, victoria
Changes your password from NULL to “16tons.” Notice that NULL is not enclosed in quotes (NULL is not a permissible new password):
sp_password null, "16tons"
PRODUCTION...sp_password figaro, lilacs
Changes your password on the PRODUCTION server from “figaro” to “lilacs.”
Any user can change his or her password with sp_password.
New passwords must be at least 6 characters long. They cannot be NULL.
The encrypted text of caller_passwd must match the existing encrypted password of the caller. If it does not, sp_password returns an error message and fails. master.dbo.syslogins lists passwords in encrypted form.
If a client program requires users to have the same password on remote servers as on the local server, users must change their passwords on all the remote servers before changing their local passwords. Execute sp_password as a remote procedure call on each remote server. See Example 4.
You can set the systemwide password expiration configuration parameter to establish a password expiration interval that forces all Adaptive Server login accounts to change passwords on a regular basis. See the System Administration Guide for more information.
Only a System Security Officer can execute sp_password to change another user’s password. Any user can execute sp_password to change his or her own password.
System procedures sp_addlogin, sp_adduser
