I need your help. My requirement is as follows.
1. My company wants to monitor the User Login/Logout time, Accessed Responsiblities, Accessed Modules, What actions he did during his login... Can we get this report?? If so pls guide..
2. Is the data in fnd_logins table get purge after 24 hours, if so how to make it not to get purge..
Thanks a lot in advance
I don't think you will be able to achieve your objective by submitting a single request/program, this may be be attained from a series of activities and the requirement is achievable.
Please refer notes:
How To Audit An Oracle Applications' User? (Doc ID 395849.1)
How To Audit Users Responsibility Changes? (Doc ID 747471.1)
Please also refer the following as it has been discussed before in the forum:
Hope this helps!
There is nothing as point 2 in my above post. But as you wanted to get have an all round information and track of login/log out timing, responsibility changes and so on.
I suggest you follow both the notes and see if it helps you attaining your objective
Hope this helps,
Assalamu alaikum Asif bro,
One of my friend sent me links for the above requirement, want to share here.
Could you please suggest where can I find the records of session user has connected, and in the same manner auto disconnected due to idle time.
Example, user e_afzal login at 9:00AM and logout at 2:00PM, in between the user e_afzal got disconnected many times due to idle time.
Report should have columns like....
User_name Login_Time Logout_time Session Session_disconn_auto_time
e_afzal 9:00AM XX 9:30AM
Thanks in advance.
If you want to get details about connected users after enabling audit then please see https://forums.oracle.com/community/developer/search.jspa?q=Connected+AND+Users
Wa Alaikum Salam Afzal brother,
Please do check Hussein's search contents as it would definitely help you.
At the same time, also have a glance on the following site as well;
Hope this helps