When you use sp_password to change your password, Adaptive Server:
Uses the original password to decrypt all the key copies that were encrypted using your login password then reencrypts them with the new password.
Updates any key copies assigned to you that are designated for login association. The key copies’ password type remains the same.
After a password change, log out of all your Adaptive Server sessions then log in again before accessing any encrypted data. Alternatively, you can use the immediate parameter of sp_password to propagate the password change to all sessions.
When the SSO issues sp_password to reset a user's password, the user’s login password-encrypted key copies are dropped by Adaptive Server because the user’s old login password is not available. Adaptive Server requires the key custodian to re-create the key copies for the user, if they are needed
