If you have DBA authority, you can change the password of any existing user with the following command:
ALTER USER userid IDENTIFIED BY password
If you inadvertently enter the user ID of an existing user when you mean to add a new user, you are actually changing the password of the existing user. You do not receive a warning because this behavior is considered normal. This behavior differs from pre-Version 12 Sybase IQ.
To avoid this situation, use the system procedures sp_addlogin and sp_adduser to add users. These procedures give you an error if you try to add an existing user ID, as in Adaptive Server Enterprise and pre-Version 12 Sybase IQ.
You can set up password rules and verify that any new password assigned complies with them. For example, you might require that passwords must include one digit or must not be the user ID. For details, see “VERIFY_PASSWORD_FUNCTION option” in the Reference: Statements and Options.
To set a minimum password length, see “MIN_PASSWORD_LENGTH option” in the Reference: Statements and Options.
The user ID DBA identifies a user with full administration
and resource creation rights. The default password for user ID DBA
for all databases is sql. You
should change this password to prevent unauthorized access to your database.
The following command changes the password for user ID DBA to new_password:
ALTER USER DBA IDENTIFIED BY new_password
To change the DBA password, you must have DBA authority.
WARNING! Never drop the DBA user for a multiplex database. Doing so makes the database unusable.
If you are using DBISQL, it is a good idea to put your permission grants into a command file for reference and so that it can be modified and run again if it is necessary to recreate the permissions.
