Wednesday, November 15, 2017

Login attempts on EBS

/*
Copyright (c) 2015 Oracle Corporation  - All rights reserved.

Query showing unsuccessful logins for local users in E-Business Suite
*/

set pagesize 1000
set linesize 200

select u.user_name,
ful.user_id,
to_char(attempt_time,'DD-MON-RRRR HH24:MI:SS') attempt_time
from fnd_unsuccessful_logins ful,
fnd_user u
where ful.user_id = u.user_id (+)
order by attempt_time;

No comments:

Post a Comment