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 Database Concepts for an introduction to local and common users in a CDB