The ALTER USER statement is used to change Oracle passwords, expire, and lock unnecessary users.
Example 1:
ALTER USER username IDENTIFIED BY newpassword;
Example 2:
ALTER USER username ACCOUNT LOCK;
Example 3:
ALTER USER username PASSWORD EXPIRE;
The ALTER USER statement is used to change Oracle passwords, expire, and lock unnecessary users.
Example 1:
ALTER USER username IDENTIFIED BY newpassword;
Example 2:
ALTER USER username ACCOUNT LOCK;
Example 3:
ALTER USER username PASSWORD EXPIRE;