FAILED_LOGIN_ATTEMPTS

• MySQL

(8.0.33)
https://dev.mysql.com/doc/refman/8.0/ja/alter-user.html
https://blog.s-style.co.jp/2020/01/5704/

drop user if exists user3;

create user user3@'%' identified by 'user3';
grant process on *.* to 'user3'@'%';

select Host, User, account_locked, User_attributes
from mysql.user;

alter user user3@'%' FAILED_LOGIN_ATTEMPTS 1 PASSWORD_LOCK_TIME 1;

alter user user3@'%' FAILED_LOGIN_ATTEMPTS 0 PASSWORD_LOCK_TIME 0;

show create user user3@'%';

• Oracle

(23c)

select * from dba_profiles where PROFILE = 'DEFAULT' and RESOURCE_TYPE = 'PASSWORD';

alter profile default limit FAILED_LOGIN_ATTEMPTS 1;
alter profile default limit PASSWORD_LOCK_TIME 1;

alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;
alter profile default limit PASSWORD_LOCK_TIME unlimited;

drop user if exists USER3;

create user USER3 identified by USER3;
grant connect to USER3;

alter session set NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS';

select USERNAME, ACCOUNT_STATUS, LOCK_DATE
from dba_users
where username='USER3';

• PostgreSQL

(15)

未対応

• SQL Server

(2022)

未対応