KingbaseES-v8r6-定期更换口令

定期更换口令

开启口令有效期策略，编辑kingbase.conf，shared_preload_libraries添加identity_pwdexp，重启数据库，创建identity_pwdexp扩展

vim /data/kingbase.conf
grep shared_preload_libraries /data/kingbase.conf
sys_ctl restart -D /data/
ksql test system
create extension identity_pwdexp ;

• 设置密码有效期10天

\c test sso
alter system set identity_pwdexp.password_change_interval = 10 ;
select sys_reload_conf();
\c test system
create user user02 password 'kingbase..1234';
\du+