A single user can manage the password of another user.
Prerequisites
- Requires 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