Oracle用户锁定/解锁(DBA用户执行) 锁定用户: alter user user_name account lock; 用户解锁: alter user user_name account unlock; 查看用户状态: #一个账号状态可以是打开的(open),也可以是锁定(locked)或过期的(expired) select username,account_status from dba_users where username = upper('user_name');