金仓V8R6数据库手动锁定、解锁用户

[kingbase@host1 ~]$ ksql test system
Password for user system:
ksql (V8.0)
Type "help" for help.

test=# create user user1 with password '123456';
CREATE ROLE
test=# \c test user1 （登录成功）
Password for user user1:
You are now connected to database "test" as user "user1".
test=>

锁定用户
 ksql test system
Password for user system:
ksql (V8.0)
Type "help" for help.
test=# alter user user1 account lock;
ALTER ROLE
test=# \c test user1  （登陆失败）
Password for user user1:
FATAL:  role "user1" is not permitted to log in
Previous connection kept
解锁用户
test=# alter user user1 account unlock;
ALTER ROLE
test=# \c test user1  （登陆成功）
Password for user user1:
You are now connected to database "test" as user "user1".