达梦数据库 - 用户状态查询、锁定与解锁，解锁“登录失败次数超过限制”

Administrator

2025-11-15

原作者：小蓝枣

查看失败限制次数、失败尝试次数和锁定时间：

select 
b.username as "达梦数据库用户名",
a.failed_num as "失败次数限制",
a.failed_attemps as "失败尝试次数",
a.lock_time as "锁定时间(min)" 
from sysusers a right join all_users b on a.id=b.user_id;

查看用户状态：

select 
username as "达梦数据库用户名", 
account_status as "账户状态",
lock_date as "锁定时间" 
from dba_users;

解锁用户锁定状态：

alter user auto_2105_dm_0529 account unlock;

锁定用户：

alter user auto_2105_dm_0529 account lock;