Manage Oracle DB users

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;

Comments are closed.