Thursday, August 25, 2011

Unsuccessful logins for the running day.

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;
Apps DBA Free Lance
Sukhwinder Singh

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

There was an error in this gadget