We know that Oracle consists of many default user accounts like SCOTT, HR etc. Till Oracle 10g, these accounts had a default password, and we had no option to find if the current password used were default ones or not.This caused a security risk if the accounts were not locked.
Inorder to deal with this situation, Oracle 11g introduced a dictionary data view called DBA_USERS_WITH_DEFPWD.This view shows which all users use default passwords.The below example lists the users with default passwords.We have to change the passwords for these usernames and probably keep the account locked too.
SQL> SELECT * FROM DBA_USERS_WITH_DEFPWD;
Article by : Divya