Our client is intersted in seeing the following reports:
1. Reports showing roles that are not being used
2. Report showing users that uses the system the most by role
3. Report showing the roles used the most for each user
4. How many times a t-code was excecuted say in one month or a week (please dont tell me to look at the number of steps and guesstimate from that 😊)
I'm an Oracle DBA and writting sql scripts will not be an issue but my questions is that what underlining table(s) can I query to get these reports? I can get a the list of roles associated with t-codes from Security team.
If anyone has any idea, i would really apperciate it.