oracle 11.2.0.4 查找还在使用默认密码的用户

在我们做安全检查的时候会让我们dba去找还在使用默认密码的用户

参考官方文档SECURITY GUIDE第三章

SQL> SELECT d.username, u.account_status
FROM DBA_USERS_WITH_DEFPWD d, DBA_USERS u
WHERE d.username = u.username
ORDER BY 2,1;  2    3    4  


USERNAME       ACCOUNT_STATUS
------------------------------ --------------------------------
APPQOSSYS       EXPIRED & LOCKED
CTXSYS       EXPIRED & LOCKED
DBSNMP       EXPIRED & LOCKED
DIP       EXPIRED & LOCKED
EXFSYS       EXPIRED & LOCKED
MDDATA       EXPIRED & LOCKED
MDSYS       EXPIRED & LOCKED
OLAPSYS       EXPIRED & LOCKED
ORACLE_OCM       EXPIRED & LOCKED
ORDDATA       EXPIRED & LOCKED
ORDPLUGINS       EXPIRED & LOCKED
ORDSYS       EXPIRED & LOCKED
OUTLN       EXPIRED & LOCKED
SI_INFORMTN_SCHEMA       EXPIRED & LOCKED
SPATIAL_CSW_ADMIN_USR       EXPIRED & LOCKED
SPATIAL_WFS_ADMIN_USR       EXPIRED & LOCKED
WMSYS       EXPIRED & LOCKED
XDB       EXPIRED & LOCKED
SCOTT       LOCKED

已选择19行。

--以上19个用户都是默认密码，不过都锁定了，无碍。