3.55 DBA_USERSThe DBA_USERS view provides information about all users of the database.
Use the edb_get_role_status(role_id) function to get the current status of the account. If the account status is LOCKED, lock_date displays the date and time the account was locked. The expiration date of the password. Use the edb_get_password_expiry_date(role_id) function to get the current password expiration date.