List of Users and Roles Assigned in Portal (producer & consumer)

Hi

We are running federated portal EP 7.0 EHP1 SPS07, we need to pull the list of users and their roles assigned from tables or thru report in our federated portal, so that we can have a consolidated list of users and their roles in both producer and consumer portal

Thanks

Senthil