It is a good idea to change your password periodically. The System Security Officer can configure Adaptive Server to require that you change your password at preset, regular intervals. If this is the case on your server, Adaptive Server notifies you when it is time to change your password.
If you use remote servers, you must change your password
on all remote servers that you access before you
change it on your local server. For more information, see “Password changes on a remote server”.
You can change your password at any time using sp_password:
sp_password old_passwd, new_passwd
When you create a new password:
It must be at least six bytes long.
It can be any printable letters, numbers, or symbols.
The maximum size for a password is 30 bytes. If your password exceeds 30 bytes, Adaptive Server uses only the first 30 characters.
When you specify a password, enclose it in quotation marks if:
It includes characters other than A–Z, a–z, 0–9, _, #, valid single-byte or multibyte alphabetic characters, or accented alphabetic characters.
It begins with a number 0–9.
The following example shows how to change the password “terrible2” to “3blindmice”:
sp_password terrible2, "3blindmice"
A return status of 0 means that the password was changed. For more information about sp_password, see the Reference Manual: Procedures.
