人大金仓数据库KingbaseES 口令有效期经验总结

修改 kingbase.conf 文件中 shared_preload_libraries 参数。

shared_preload_libraries = 'identity_pwdexp'.

\c - system

create extension identity_pwdexp;

CREATE EXTENSION

\c - sso

show identity_pwdexp.password_change_interval;

identity_pwdexp.password_change_interval

--------------------------

30

(1 row)

alter system set identity_pwdexp.password_change_interval = 5;

ALTER SYSTEM

show identity_pwdexp.password_change_interval;

identity_pwdexp.password_change_interval

------------------------------------------

0

(1 行记录)

select sys_reload_conf();

sys_reload_conf

-----------------

t

(1 行记录)

show identity_pwdexp.password_change_interval;

identity_pwdexp.password_change_interval

------------------------------------------

5

(1 行记录)

\c - system

call now();

now

-------------------------------

2020-04-30 15:34:30.408304+08

(1 行记录)

CREATE USER u_pwd_et PASSWORD '1234567890abC/.' VALID UNTIL '

2020-05-01';

CREATE ROLE

SELECT USENAME, VALUNTIL FROM SYS_USER WHERE USENAME ='u_pwd_et';

usename | valuntil

----------+------------------------

u_pwd_et | 2020-05-01 00:00:00+08

(1 行记录)

ALTER USER u_pwd_et PASSWORD '/.1234567890abC';

警告: user "u_pwd_et" does not be locked

ALTER ROLE

SELECT USENAME, VALUNTIL FROM SYS_USER WHERE USENAME =

'u_pwd_et';

usename | valuntil

----------+-------------------------------

u_pwd_et | 2020-05-05 15:35:23.448381+08

(1 行记录)