Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ FAQs/ How Do I Create a Weak Password in GaussDB?
Updated on 2025-05-29 GMT+08:00

How Do I Create a Weak Password in GaussDB?

Answer: In the GaussDB database, the weak password dictionary is empty by default. You can manually add one or more weak passwords to the gs_global_config system catalog.

Example:

-- Insert a single weak password into the gs_global_config system catalog.
gaussdb=# CREATE WEAK PASSWORD DICTIONARY WITH VALUES ('password1');

-- Insert multiple weak passwords into the gs_global_config system catalog.
gaussdb=# CREATE WEAK PASSWORD DICTIONARY WITH VALUES ('password2'),('password3');

-- Check weak passwords in the gs_global_config system catalog.
gaussdb=# SELECT * FROM gs_global_config WHERE NAME LIKE 'weak_password';
      name       |     value      
-----------------+----------------
 weak_password   | password1
 weak_password   | password2
 weak_password   | password3
(3 rows)