← 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