金仓数据库限制用户过期时间

修改kingbase.conf配置文件并重启数据库
在shared_preload_libraries参数末尾添加identity_pwdexp
重启数据库之后，登录数据库看设置是否生效
test=# show shared_preload_libraries ;
                                                                                                                                                
                   shared_preload_libraries                                                                                                     
                                                               
------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------
 kdb_date_function,liboracle_parser, synonym, plsql, force_view, kdb_flashback,plugin_debugger, plsql_plugin_debugger, plsql_plprofiler, ora_com
mands,kdb_ora_expr, sepapower, dblink, sys_kwr, sys_ksh, sys_spacequota, sys_stat_statements, backtrace, kdb_utils_function, auto_bmr,sys_squeez
e,src_restrict,kdb_database_link,passwordcheck,identity_pwdexp
(1 row)
创建扩展
test=# create extension identity_pwdexp;
CREATE EXTENSION
设置密码有效期为5天
[kingbase@host1 ~]$ ksql test sso
Password for user sso:
ksql (V8.0)
Type "help" for help.
test=> alter system set identity_pwdexp.password_change_interval =5;
ALTER SYSTEM
test=> select sys_reload_conf();
 sys_reload_conf
-----------------
 t
(1 row)
test=> alter system set identity_pwdexp.max_password_change_interval =5;
ALTER SYSTEM
test=> select sys_reload_conf();
 sys_reload_conf
-----------------
 t
(1 row)
新建一个用户
ksql test system
Password for user system:
ksql (V8.0)
Type "help" for help.
test=# create user user1 password 'user_123456';
CREATE ROLE
查看用户密码有效期为5天
test=# select now();
              now              
-------------------------------
 2023-11-15 15:13:19.655449+08
test=# select usename,valuntil from sys_user where usename='user1';
 usename |           valuntil            
---------+-------------------------------
 user1   | 2023-11-20 15:12:16.616540+08
(1 row)