Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2005
    Posts
    52

    Unanswered: username with defult password

    Hi,

    I would like to write a scripts that find defult p/w for the username. I have the below one but the problem is I can not save thr output in a file.

    If any one has got suggestion pl. provide it to me.

    set head off
    set feed off
    set verify off
    set termout off
    spool use.run
    col user_id newline
    col show_it newline
    select 'spool use.lis' from sys.dual;
    select 'connect '||username||'/'||username user_id,
    'select ''connected as ''||user||'' with password ''||user from sys.dual;' show_it
    from dba_users;
    select 'spool off' from sys.dual;
    spool off
    set head on
    set feed on
    set verify on
    set termout on
    @@use.run


    Thanx in adv.

  2. #2
    Join Date
    May 2006
    Posts
    132
    This script will check for default password for 8.1.7 - 9.2.0:

    Code:
    select username "User(s) with Default Password!", account_status "Status"
     from dba_users
     where password in
    ('E066D214D5421CCC',  -- dbsnmp
     '24ABAB8B06281B4C',  -- ctxsys
     '72979A94BAD2AF80',  -- mdsys
     '9AAEB2214DCC9A31',  -- mdsys
     'C252E8FA117AF049',  -- odm
     'A7A32CD03D3CE8D5',  -- odm_mtr
     '88A2B2C183431F00',  -- ordplugins
     '7EFA02EC7EA6B86F',  -- ordsys
     '9B616F5489F90AD7',  -- ordcommon
     '4A3BA55E08595C81',  -- outln
     'F894844C34402B67',  -- scott
     '3F9FBD883D787341',  -- wk_proxy
     '79DF7A1BD138CF11',  -- wk_sys
     '7C9BA362F8314299',  -- wmsys
     '88D8364765FCE6AF',  -- xdb
     'F9DA8977092B7B81',  -- tracesvr
     '9300C0977D7DC75E',  -- oas_public
     'A97282CE3D94E29E',  -- websys
     'AC9700FD3F1410EB',  -- lbacsys
     'E7B5D92911C831E1',  -- rman
     'AC98877DE1297365',  -- perfstat
     '66F4EF5650C20355',  -- exfsys
     '84B8CBCA4D477FA3',  -- si_informtn_schema
     'D4C5016086B2DC6A',  -- sys
     '5638228DAF52805F',  -- sys
     'D4DF7931AB130E37')  -- system
    /
    Also, 10g has Patch# 4925128 which includes a Default Password Scanner.

    .

  3. #3
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    Very neat. Also appears to work in 10.1:

    Code:
    User(s) with Default Password! Status
    ------------------------------ --------------------------------
    SCOTT                          OPEN
    OUTLN                          EXPIRED & LOCKED
    WMSYS                          EXPIRED & LOCKED
    ORDSYS                         EXPIRED & LOCKED
    MDSYS                          EXPIRED & LOCKED
    EXFSYS                         EXPIRED & LOCKED
    XDB                            EXPIRED & LOCKED
    SI_INFORMTN_SCHEMA             EXPIRED & LOCKED
    ORDPLUGINS                     EXPIRED & LOCKED
    
    9 rows selected.

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    I've used the attached (Oracle provided) script on 9i databases...
    Attached Files Attached Files
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •