DBA FUS‎ > ‎

Password Life Time

posted Sep 13, 2010, 5:47 AM by Sachchida Ojha
SELECT profile, limit
    FROM   dba_profiles,
           (SELECT limit AS def_pwd_life_tm
            FROM   dba_profiles
            WHERE  profile = 'DEFAULT'
            AND    resource_name = 'PASSWORD_LIFE_TIME')
    WHERE  resource_name = 'PASSWORD_LIFE_TIME'
    AND    ((replace(limit,'DEFAULT',def_pwd_life_tm) IN ('UNLIMITED',NULL))
      OR    (lpad(replace(limit,'DEFAULT',def_pwd_life_tm),40,'0') >
             lpad('90',40,'0')));
Comments