If you connect to the _users table in the Repository you will see the list of users, their site roles, the sites they have access to, and when they last logged in.
This should give you everything you need
All the best
Hey Arun Yadav here is a Powershell script you can run to export the roles of all users:
If this comment is helpful please mark it as such.