Help Center/ GaussDB(DWS)/ More Documents/ User Guide(ME-Abu Dhabi Region)/ FAQs/ Account Permissions/ How Do I Change the Password of a GaussDB(DWS) Database Account When It Expires?
Updated on 2025-05-27 GMT+08:00

How Do I Change the Password of a GaussDB(DWS) Database Account When It Expires?

Below are the methods for changing the password of a database account:

  • To change the password of the database administrator dbadmin, log in to the console and choose More > Reset Password in cluster row.
    Figure 1 Resetting the password of user dbadmin
  • You can also connect to the database and run the ALTER USER command to change the password validity period of a database account (common user and administrator dbadmin).
    1
    ALTER USER username PASSWORD EXPIRATION 90;