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