DBA_USERS_WITH_DEFPWD displays all users in the database that are still using their default passwords.
DBA_USERS_WITH_DEFPWD
USERNAME
VARCHAR2(30)
NOT NULL