DBA FUS‎ > ‎

Account Lock Time

posted Sep 13, 2010, 5:50 AM by Sachchida Ojha
SELECT profile, limit
    FROM   dba_profiles,
           (SELECT limit AS def_pwd_lock_tm
            FROM   dba_profiles
            WHERE  profile = 'DEFAULT'
            AND    resource_name = ' PASSWORD_LOCK_TIME ')
    WHERE  resource_name = ' PASSWORD_LOCK_TIME '
    AND    ((replace(limit,'DEFAULT',def_pwd_lock_tm) IN ('UNLIMITED',NULL))
      OR    (lpad(replace(limit,'DEFAULT',def_pwd_lock_tm),40,'0') <
             lpad('.0104',40,'0')));
Comments