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