1、修改kingbase.conf后方追加
shared_preload_libraries参数添加sys_audlog
sys_audlog.error_user_connect_times=5
sys_audlog.error_user_connect_interval=30
2、查看参数:
test=# show sys_audlog.error_user_connect_times ;
sys_audlog.error_user_connect_times
-------------------------------------
5
(1 行记录)
3、例子:
test=# create user user_lock with password '12345678ab!';
CREATE ROLE
test=# \q
[kingbase@r6 data]$ ksql -Uuser_lock -p 54321 -W test
口令:
注:需要加-W参数,不加的话回车算一次失败,输入错误算一次失败,共两次
ksql: 错误: 无法连接到服务器:致命错误: password authentication failed for user "user_lock"
NOTICE: This is the 1 login failed. There are 4 left.
[kingbase@r6 data]$ ksql -Uuser_lock -p 54321 -W test
口令:
ksql: 错误: 无法连接到服务器:致命错误: password authentication failed for user "user_lock"
NOTI