Oracle view DBA_USERS contains a lot of useful information about database users.
Before you begin
Please note that you need need special privilege to access DBA_USERS view (usually dba).
select username, account_status from DBA_USERS
- username - name of the user
- account_status - account status:
- EXPIRED & LOCKED(TIMED)
- EXPIRED(GRACE) & LOCKED(TIMED)
- EXPIRED & LOCKED
- EXPIRED(GRACE) & LOCKED
- One row represents one user
You can see users list on our test server. Many accounts are created during database installation.