Expiring and Locking Database Accounts

When you expire the password of a user, that password no longer exists. If you want to unexpire the password, you change the password of that account. Locking an account preserves the user password and other account information, but makes the account unavailable to anyone who tries to log in to the database using that account. Unlocking it makes the account available again.

Administering Database User Accounts explains how you can use Database Control to unlock database accounts. You also can use Database Control to expire or lock database accounts.

To expire and lock a database account: 

1. Start Database Control.

   See Accessing the Database Home Page for instructions about how to start Database Control.

2. Log in with administrative privileges.

   For example:

   The Database Home page appears.

3. Click Server to display the Server subpage.

4. In the Security section, click Users.

   The Users page lists the user accounts created for the current database instance. The Account Status column indicates whether an account is expired, locked, or open.

5. In the Select column, select the account you want to expire, and then click Edit.

   The Edit User page appears.

6. Do one of the following:

   • To expire a password, click Expire Password now.

     To unexpire the password, enter a new password in the Enter Password and Confirm Password fields. See "Requirements for Creating Passwords" for password requirements.

   • To lock the account, select Locked.

7. Click Apply.