select count (ul.user_id)
from fnd_unsuccessful_logins ul, fnd_user u
where ul.user_id = u.user_id
and ul.attempt_time > NVL (u.last_logon_date, u.last_update_date)
and ul.user_id = u.user_id
and u.user_name = '&username';
from fnd_unsuccessful_logins ul, fnd_user u
where ul.user_id = u.user_id
and ul.attempt_time > NVL (u.last_logon_date, u.last_update_date)
and ul.user_id = u.user_id
and u.user_name = '&username';
No comments:
Post a Comment