If you need to change a user password in Sybase IQ, use the following command. But, in order to execute this command, your ID must have DBA or PERMS ADMIN authority.
ALTER USER [USER-ID] IDENTIFIED BY [NEW-PASSWORD]
Example here, to change password for username, ITSITI to p@s1rMA$.
ALTER USER ITSITI IDENTIFIED BY p@s1rMA$
PS: The command is similar like Oracle’s command.
