How to Change A User Password in Sybase IQ



Share this article :

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.

Related posts

User 'another user' has the row in 'ITSITI' locked
How to Add New Data File into Existing DBspace (Sybase IQ)
How to Increase/Extend Data File(s) Size in Sybase IQ
sp_iqlmconfig: Sybase IQ License Management
© 2018 ITsiti. All Rights Reserved
Powered by KEEM