11.6.2 Changing an HADB user's password
To change an HADB user's password, use the ALTER USER definition SQL statement. The following shows an example of changing the password of an HADB user.
- Specification example
-
The password of HADB user ADBUSER02 is changed to #HelloHADB_03.
ALTER USER "ADBUSER02" IDENTIFIED BY '#HelloHADB_03'
- Important
-
-
An HADB user who does not have the DBA privilege can change only his or her own password (that of the HADB user whose authorization identifier was used for the current connection to the HADB server). Such a user cannot change the password of another HADB user.
-
An HADB user who has the DBA privilege can change their own password. They can also change the passwords of other HADB users. However, they cannot change the password of an HADB user who has the audit privilege.
-
- Note
-
-
When changing the password of an HADB user, we recommend that you use a minimum of eight characters for the new password.
-
We also recommend that you change passwords regularly.
-
For details about the specification rules for passwords of HADB users, see 9.4.3 Password specification rules.
-