[Oracle] Unlock user that has expired password (사용자 계정 잠금/해제)

Check default password expiration time (기본 비밀번호 만료 기간 확인)

SELECT RESOURCE_NAME, LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT' AND RESOURCE_NAME LIKE 'PASSWORD%';

Set password expiration disabled (비밀번호 만료 해제)

ALTER PROFILE DEFAULT LIMIT  PASSWORD_LIFE_TIME UNLIMITED;

Check users have expired password (비밀번호 만료된 유저 확인)

SELECT USERNAME, ACCOUNT_STATUS, LOCK_DATE, EXPIRY_DATE FROM DBA_USERS WHERE ACCOUNT_STATUS = 'EXPIRED';

Unlock user (잠금계정 해제)

ALTER USER [USER_NAME] IDENTIFIED BY [USER_NAME];

[H2] How to check table lock in H2 database

SELECT * FROM INFORMATION_SCHEMA.LOCKS;

SELECT * 
  FROM INFORMATION_SCHEMA.LOCKS
 WHERE TABLE_SCHEMA = '<SCHEMA_NAME>'
   AND TABLE_NAME = '<TABLE_NAME>'
;