You can expire a user password using Oracle Enterprise Manager Database Express (EM Express). When you expirea user password, the user is prompted to change his or her password the next time that user logs in. Reasons to expire a password include the following:
A user password becomes compromised.
You have a security policy in place that requires users to change their passwords on a regular basis.
Note:
You can automate the automatic expiring of user passwords after a certain interval. See "Setting the Database Password Policy".
A user has forgotten his or her password.
In this third case, you modify the user account, assign a new temporary password, and expire the password. The user then logs in with the temporary password and is prompted to choose a new password.
To expire a user password:
In EM Express, go to the Users page, as described in "Viewing User Accounts".
Click the desired user account.
From the Actions menu, select Alter Account.
The Alter Account page appears.
Enable Password Expired, and then click OK.