DROP WEAK PASSWORD DICTIONARY

Description

DROP WEAK PASSWORD DICTIONARY is used to clear the weak password dictionary. You can run this statement to clear all weak passwords in the gs_global_config system catalog.

Precautions

Only the initial user, system administrators, and security administrators have the permission to execute this syntax.

Syntax

DROP WEAK PASSWORD DICTIONARY;

Examples

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

-- 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   | ********
(1 rows)
  
-- Clear all weak passwords in the gs_global_config system catalog.
gaussdb=# DROP WEAK PASSWORD DICTIONARY;  

-- View existing weak passwords.
gaussdb=# SELECT * FROM gs_global_config WHERE NAME LIKE 'weak_password';
 name | value 
------+-------
(0 rows)

Helpful Links

CREATE WEAK PASSWORD DICTIONARY