DBA FUS‎ > ‎

Failed Login Attempts

posted Sep 13, 2010, 6:25 AM by Sachchida Ojha
select profile||': '||limit from dba_profiles,
           (SELECT limit AS def_login_attmpts
            FROM   dba_profiles
            WHERE  profile = 'DEFAULT'
            AND    resource_name = 'FAILED_LOGIN_ATTEMPTS')
    WHERE  resource_name='FAILED_LOGIN_ATTEMPTS'   
    AND    ((replace(limit,'DEFAULT',def_login_attmpts) IN ('UNLIMITED',NULL))
      OR    (lpad(replace(limit,'DEFAULT',def_login_attmpts),40,'0') >
             lpad('3',40,'0')));
Comments