Viewing Database Users

You edit an existing database user account on the Manage Database Users page.

To edit an existing user account:

On the Database Home Page, click the Administration icon and then Database Users.
If prompted, enter the appropriate administrator username and password and click Login.

The Manage Database Users page appears.

By default each account displays as a large icon. The appearance of each icon indicates the current account status:
- A small lock image indicates that the account is locked. Locking an account disables the database login.
  
  Description of the illustration accnt_locked.gif
- A small clock image indicates that the account has an expired password. If an account has an expired password, the user will be prompted to select a new password upon the next login.
  
  Description of the illustration accnt_expired.gif
- A small lock image and a clock image indicate that the account is both expired and locked.
  
  Description of the illustration accnt_expire_lock.gif
- Icons without a small lock or clock image are open and available to users.
You can use the fields and buttons at the top of the page to search for a specific user or alter the page view.
To search for an existing database user:
- To locate a specific user, type a username or partial string in the Search Username field and click Go.
- To view all users, leave the Search Username field blank and click Go
To alter the types of users that display, make a selection from the Show list and click Go. Available options include:
- All Users
- Internal Users
- Database Users
To change the page display, make a selection from the View list. View options include:
- Icons (the default) displays each database user account as a large icon identified by the username.
- Details displays each database user account as a line in a report. Each line includes the username, account status, lock date, expiration date, default tablespace, temporary tablespace, and how long ago the account was created.