select profile||': '||limit from dba_profiles, (SELECT limit AS def_login_attmpts FROM dba_profiles WHERE profile = 'DEFAULT' AND resource_name = 'FAILED_LOGIN_ATTEMPTS') WHERE resource_name='FAILED_LOGIN_ATTEMPTS' AND ((replace(limit,'DEFAULT',def_login_attmpts) IN ('UNLIMITED',NULL)) OR (lpad(replace(limit,'DEFAULT',def_login_attmpts),40,'0') > lpad('3',40,'0'))); |
DBA FUS >