Example: User John Doe has 5 roles in production that each have several privileges:
- Role 1
- Privilege A
- Privilege B
- Privilege C
- Role 2
- Privilege D
- Privilege E
- Privilege F
- Privilege G
- Role 3
- Privilege H
- Privilege I
- Role 4
- Privilege J
- Privilege K
- Role 5
- Privilege L
- Privilege M
- Privilege N
What I’m looking for is a tool that can tell me that user John Doe hasn’t used Privileges A, D, H, I, K, or N over a given period of time. Based on that information I’d then be able to remove Role 3 since the user isn’t using either privilege, and I’d probably also evaluate if there’s a different role that the user could have instead of role 4 since the user only needs one of the privileges.
is this data stored in any of these tables