Answers for "oracle unlock a user"

SQL
1

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
0

oracle unlock account

ALTER USER "MY_SCHEMA_NAME" ACCOUNT UNLOCK;
Posted by: Guest on January-18-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language