Currently, there aren’t any API endpoints or CSV exports which would provide project access details for users to meet your requirements.
With TestRail Server, you would be able to query this data from the database directly. While I don’t have an exact set of queries to provide, you should be able to use the project-related and role-related tables to collect the access data you need for users.
User permissions in projects are provided in this order, highest precedence to lowest:
- User’s role assignment inside the project
- User’s group role assignment inside the project
- Project’s default role assignment
- User’s ‘global’ role assigned under
Administration > Users & Roles
As always, we would recommend never making any changes directly to TestRail’s database, as any changes to data should be made through TestRail’s UI or API when needed. Changes made directly to TestRail’s database can lead to data inconsistencies and corruption within TestRail.
I hope this helps,