Wednesday, February 24, 2016

Unsuccessful logins

Unsuccessful logins

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;

No comments:

Post a Comment