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

来源：互联网发布：led单色显示屏软件编辑：程序博客网时间：2024/05/21 22:57

在我们做安全检查的时候会让我们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个用户都是默认密码，不过都锁定了，无碍。

0 0