1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_ZONEMAPS
  4. DBA_USERS_WITH_DEFPWD

6.98 DBA_USERS_WITH_DEFPWD

DBA_USERS_WITH_DEFPWD displays all users in the database that are still using their default passwords.

Column Datatype NULL Description

USERNAME

VARCHAR2(128)

NOT NULL

Name of the user

PRODUCT

VARCHAR2(4000)

Name of the product the user belongs to

Note:

In a CDB, when DBA_USERS_WITH_DEFPWD is queried from a PDB, information about local users who are using their default passwords is displayed. To display information about common users, query DBA_USERS_WITH_DEFPWD from the root.

See Also:

Oracle Multitenant Administrator's Guide for an introduction to local and common users in a CDB