Unsuccessful logins
                                                 Last update (2008-06-09 14:10:16)
                                                                                                                   Date added (2008-06-09 14:08:36)

Summary
If you have set up auditing in Oracle E-Business Suite then you can monitor the unsuccessful logins from the applsys.FND_UNSUCCESSFUL_LOGINS table.

For example, the unsuccessful logins for the running day.
SELECT B.USER_NAME, U.ATTEMPT_TIME
FROM applsys.FND_UNSUCCESSFUL_LOGINS U, applsys.FND_USER B
WHERE U.USER_ID = B.USER_ID
--AND B.USER_NAME LIKE NVL(:USER_NAME, '%')
AND TRUNC(U.ATTEMPT_TIME) > TRUNC(SYSDATE-1)
ORDER BY U.ATTEMPT_TIME;
Reviews
Filters
Search