← Users & Privileges
Oracle · Users & Privileges

How to check accounts with default passwords in Oracle

Find Oracle accounts still using a known default password with DBA_USERS_WITH_DEFPWD. Oracle 11g and later.

Tested on11g12c19c21c23ai26ai

Accounts that still use a known default password, from DBA_USERS_WITH_DEFPWD, joined to their current status. One of the first checks on an inherited database. Oracle 11g and later.

SELECT d.username,
       u.account_status,
       u.profile
FROM   dba_users_with_defpwd d
       JOIN dba_users u ON u.username = d.username
ORDER  BY d.username;
securitydefault-passworddba_users_with_defpwd