Niall's Oracle Pages – Oracle Opinion since 2004

Quick Check for vulnerable accounts

without comments

New to me in 11g is the view DBA_USERS_WITH_DEFPWD which checks both for users with default passwords and those whose password is equal to their username. The query below might be a useful  addition to your support toolbox.

select u.username,u.account_status
from dba_users u inner join dba_users_with_defpwd p
on (u.username = p.username);

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
OUTLN                          LOCKED
DIP                            LOCKED
ORACLE_OCM                     LOCKED
WMSYS                          LOCKED
CTXSYS                         LOCKED
XXXX                           OPEN

Possibly Related Posts:

  • No Related Posts found

Written by Niall Litchfield

June 7th, 2012 at 10:15 am

Posted in Uncategorized

Tagged with

Leave a Reply

%d bloggers like this: