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')));
Want to post your scripts here in this blog ? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts.
Wednesday, January 13, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment