Can we fetch login data of all users for a year with Login Date and not LAST LOGIN DATE? All logins
We have a audit requirement to present them with data of all users and all their logins in the past 1 year.
For eg if a user XYZ has logged in 10 times into the instance we require 10 rows of the user saying XYZ(user name), role name and login date for time frame 1st Jul 2022 to 25-JUL-2023(today).
Possibilites tried: FND_SESSIONS which stores data upto 7 days and ASE_USER_LOGIN_INFO which is just giving the LAST LOGIN DATE and not the login dates for a user for a particular time period.
We need this data to comply with Audit Norms/Regulations.