ユーザアカウントのロック

(5.7)

select user,host, account_locked from mysql.user;

alter user user10 account lock;
alter user user10 account unlock;

 

(12cR1)

select username,account_status from dba_users order by username;

alter user user10 account lock;
alter user user10 account unlock;

 

(9.4)

\du

alter user user10 nologin;
alter user user10 login;

(2014)

select name,is_disabled from sys.server_principals;

alter login user10 disable;
alter login user10 enable;