A single user can manage the password of another user.
Prerequisites
- The CHANGE PASSWORD system privilege.
- The
managing user has been granted the right to change the password
of the target user.
TaskAt a command prompt, type:
ALTER USER userID
IDENTIFIED BY password