Wednesday, January 13, 2010

Password Life Time

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')));

No comments:

Post a Comment