金仓数据库手动限制用户登录

到数据库服务器上
su - kingbase
使用超级用户登录数据库、并创建测试用户
ksql test system
test=# create user user1 with password '123456';
test=# \c test user1  (切换到新建用户)
Password for user user1:
You are now connected to database "test" as user "user1".
test=> \q  （退出）
手动限制用户登录
ksql test system
test=# alter user user1 nologin;
进行验证
test=# \c test user1 (user1用户无法登录，限制成功用户)
Password for user user1:
FATAL:  role "user1" is not permitted to log in
Previous connection kept