Answers for "how to automatically unlock a user if user is locked in oracle"

oracle unlock user

-- Unlock a user
ALTER USER my_user ACCOUNT UNLOCK;
-- If password is expired 
ALTER USER my_user IDENTIFIED BY new_password ACCOUNT UNLOCK;

Posted by: Guest on January-27-2021

Code answers related to "how to automatically unlock a user if user is locked in oracle"