Adds or changes a password for a Sybase IQ user account.
call sp_iqpassword (‘caller_password’, ‘new_password’ [, ‘userid’])
sp_iqpassword ‘caller_password’, ‘new_password’ [, ‘userid’]
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.
userid Login name of the user whose password is being changed by the DBA. Do not specify userid 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 Login Management is enabled with sp_iqmodifyadmin, or immediately if IQ Login Management is already enabled.
The following errors may occur. Causes are listed after each error.
RAISERROR executed: 'You do not have permission to change this password.'
Cause: A user without DB authority tried to change another user’s password.
RAISERROR executed: 'Userid <userid> not found.'
Cause: An invalid userid was specified.
RAISERROR executed: 'Missing procedure definition for sp_iqrpcpassword. DBA must run sp_iqmpxdroppublication followed by sp_iqmpxcreatepublication.'
Cause: Database was upgraded but post-upgrade multiplex configuration steps were not performed.
RAISERROR executed: 'Password change on query server not allowed. User DBA does not have remote login permission on write server.'
Cause: Database was upgraded but post-upgrade multiplex configuration steps were not performed.
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')
