oracle list user locked
SELECT * FROM DBA_USERS WHERE ACCOUNT_STATUS <> 'OPEN';
-- Unlock a user
ALTER USER my_user ACCOUNT UNLOCK;
-- If password is expired
ALTER USER my_user IDENTIFIED BY new_password ACCOUNT UNLOCK;oracle list user locked
SELECT * FROM DBA_USERS WHERE ACCOUNT_STATUS <> 'OPEN';
-- Unlock a user
ALTER USER my_user ACCOUNT UNLOCK;
-- If password is expired
ALTER USER my_user IDENTIFIED BY new_password ACCOUNT UNLOCK;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
