6.107 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 |
|---|---|---|---|
|
|
|
|
Name of the user |
|
|
|
|
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