达梦用户登录锁定 登录次数超过限制 登录失败

查失败次数锁定时间

-- 查失败次数锁定时间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 NMGJTT_OA account unlock;