Password complexity policies in GBase 8a MPP Cluster are controlled by a set of cluster‑wide parameters. Once applied, they affect every user immediately — there is no per‑user override.

1. Where to Set Them

These are read‑only parameters that must be added to the configuration files at both layers and applied with a cluster restart:

GCluster layer : $GCLUSTER_BASE/config/gbase_8a_gcluster.cnf

GNode layer : $GBASE_BASE/config/gbase_8a_gbase.cnf

Add the identical block to both files:

password_min_length = 8 password_format_option = 3 password_not_same_reverse_username = 1 password_max_contain_continuous_char = 4 password_reuse_max = 3 password_life_time = 30 login_attempt_max = 6

Enter fullscreen mode

Exit fullscreen mode

Then restart: gcluster_services all restart

2.…