CREATE usergroup day1 SET PARAMETER 'minimal_password_length'='6','last_used_passwords'='0','minimum_password_lifetime'='0','maximum_password_lifetime'='1','password_expire_warning_time'='0';
CREATE usergroup day2 SET PARAMETER 'minimal_password_length'='6','last_used_passwords'='0','minimum_password_lifetime'='0','maximum_password_lifetime'='2','password_expire_warning_time'='1';

CREATE USER test1 password Abc123 SET usergroup day1;
CREATE USER test2 password Abc123 SET usergroup day2;

-- create connections for above users
-- initial password change handled by DBeaver

ALTER USER <user_name> FORCE PASSWORD CHANGE

-- forced password change handled by DBeaver

-- wait a day

-- expired password handled by DBeaver
-- expire warning shown by DBeaver