First page Back Continue Last page Graphics
Example: DBA_USERS
Show all users created in the database
Notes:
The names, account status, creation date and other information about Oracle user accounts on the database can be obtained by querying the DBA_USERS data dictionary view.
The ACCOUNT_STATUS column indicates the following:
OPEN – The username can be used, i.e. you can logon to the database with the username if you know the password.
EXPIRED – The password has expired, either manually with the ALTER USER PASSWORD EXPIRE command, or automatically by exceeding the lifetime of the password (see the PASSWORD_LIFE_TIME parameter on the CREATE PROFILE command.) The user will be prompted for the existing password and a new password upon login.
LOCKED – The username has been locked either manually with the ALTER USER ACCOUNT LOCK command or by exceeding the login attempt limit (see the FAILED_LOGIN_ATTEMPTS parameter of the CREATE PROFILE command).
Supplemental Notes
Additional details about user accounts can be accessed from different data dictionary views. For example, DBA_TS_QUOTAS contains information about tablespace quotas (i.e. the amount of disk space a user can use).