Persist all policies instead of active policies

What does this MR do and why?

Addresses #464270 (closed)

This MR updates the logic to persist security policies to consider inactive policies too rather than only active policies.

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.