Changes a user’s password. The preferred way to create a user is by using the CREATE USER statement. See “CREATE USER statement,” in Chapter 1, “SQL Statements,” in Reference: Statements and Options.
call sp_iqpassword (‘caller_password’, ‘new_password’ [, ‘user_name’])
sp_iqpassword ‘caller_password’, ‘new_password’ [, ‘user_ name’]
None to set your own password; DBA or PERMS ADMIN 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 or PERMS ADMIN is changing another user’s password, caller_password is the DBA or PERMS ADMIN password.
new_password New password for the user, or for loginname.
user_name Login name of the user whose password is being changed by the DBA or PERMS ADMIN. Do not specify user_name when changing your own password.
Any user can change his or her own password using sp_iqpassword. The DBA or PERMS ADMIN authority can change the password of any existing user.
Example 1 Changes the password of the logged in user from irk103 to exP984:
sp_iqpassword 'irk103', 'exP984'
Example 2 Changes the password of user joe from eprr45 to pdi032 only if the logged in user has DBA or PERMS ADMIN privileges or the user is joe himself:
call sp_iqpassword ('eprr45', 'pdi932', 'joe')