Adds or changes a password for a Sybase IQ user account.
call sp_iqpassword (‘caller_password’, ‘new_password’ [, ‘loginname’ ])
sp_iqpassword ‘caller_password’, ‘new_password’ [, ‘loginname’ ]
None to set your own password; DBA authority required to set other users’ passwords.
caller_password Your password. When you are changing your own password, this is your old password. When the DBA is changing another user’s password, caller_password is the DBA’s password.
new_password New password for the user, or for loginname.
loginname Login name of the user whose password is being changed by the DBA. Do not specify loginname when changing your own password.
Any user can change his or her own password using sp_iqpassword. The DBA can change the password of any existing user. Changes take effect when Sybase IQ User Administration is enabled with sp_iqmodifyadmin, or immediately if IQ User Administration is already enabled.
The following procedure calls by a DBA set the password of the user Jack to jacknew.
sp_iqpassword 'SQL', 'jacknew', 'jack'
call sp_iqpassword ('SQL', 'jacknew', 'jack')
