select
user_name,
CREATE_TIME,
LAST_SUCCESSFUL_CONNECT,
LAST_INVALID_CONNECT_ATTEMPT,
LAST_PASSWORD_CHANGE_TIME,
PASSWORD_CHANGE_NEEDED,
IS_PASSWORD_LIFETIME_CHECK_ENABLED,
USER_DEACTIVATED,
DEACTIVATION_TIME
from users
where user_name like 'ユーザー名'
-- and (LAST_SUCCESSFUL_CONNECT is null or USER_DEACTIVATED = 'TRUE')
order by user_name
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme