Change the password for a user by using the ALTER USER statement with an IDENTIFIED BY clause.
Any user can change their own password. To change the password for another user, you must have the CHANGE PASSWORD system privilege.
If you are changing your own password and your login policy has dual control password changing set to ON, you can still change your password normally; dual control password changing is not required for you to change your own password.
Context and remarks
Passwords are case-sensitive and they cannot:
Connect to the database.
Execute an ALTER USER statement that contains an IDENTIFIED BY clause specifying the new password.
Execute the following statement to change the password for the DBA user to welcome_DBA:
ALTER USER DBA IDENTIFIED BY welcome_DBA;
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|