1. What is the nature and description of the request?

Currently, when a team in one organization (e.g., Team A in Organisation A) is assigned 'Execute' permissions on Projects, Job Templates, and Workflow Templates in another organization (e.g., Organisation B), Role Team Assignment records accumulate rapidly as the number of organizations and job templates grows.

This leads to:

Performance degradation when querying permissions via the ansible.controller.controller_api.

A need to increase max_objects to retrieve results, which is a temporary workaround and impacts overall system performance.

1. Why does the customer need this? (List the business requirements here)

We have users in operational roles who require limited access to multiple organizations, without granting them full Administrator permissions. This enhancement would simplify permission management and reduce system overhead.

1. How would you like to achieve this? (List the functional requirements here)

feature request to allow the ability for a Team in Organization A to provide access to other organizations without needing to create individual Role Team Assignments for each resource.

1. Github Link if any

https://github.com/ansible/awx/issues/9128