Resolve vulnerability cross join issues in `ee/app/services/vulnerabilities/remove_all_vulnerabilities_service.rb`

Gregory Havenga (is on PTO from 15 December 2025 to 02 January 2026)requested to merge
474142-resolve-vulnerability-cross-join-issues-in-ee-app-workers-vulnerabilities into master

What does this MR do and why?

During the sec-decomposition it was necessary to permit interactions between tables that would be moving to the gitlab-sec schema until they were all transitioned, until a later configuration change made this unnecessary. The allowances in this MR were of this transitional nature, and require no remediation.

The file changed differs from the one stipulated in the issue as the code which was permitted to make the inter-table interactions was moved from the worker to this service as part of a refactor effort.

The changes in this MR have no functional impact on GitLab.

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #474142 (closed)

Edited by Gregory Havenga (is on PTO from 15 December 2025 to 02 January 2026)

Merge request reports