To manage an Oracle DB user account use the commands listed below.
Change user account password:ALTER USER username IDENTIFIED BY new_password;
Lock and unlock a user account:ALTER USER username ACCOUNT UNLOCK;
ALTER USER username ACCOUNT UNLOCK;
Force user to change password at next logon:ALTER USER username PASSWORD EXPIRE;
Drop a user from the database:DROP USER username CASCADE;