Description of problem: Following minor update from 16.2.5 to 16.2.6, RBAC no longer works for some networks. 2023-11-20 13:26:01.179 32 INFO neutron.pecan_wsgi.hooks.translation [req-35594b55-cf0d-4895-bed0-66d02123990a ad35ecf7666ba6a0b9baa5fef0421ea94258a7c3d28bf164a1f48eb914f6d213 38b5b8cd675d44d298cf6f671795b136 - 62cf1b5ec006489db99e2b0ebfb55f57 62cf1b5ec006489db99e2b0ebfb55f57] POST failed (client error): Tenant 38b5b8cd675d44d298cf6f671795b136 not allowed to create port on this network Version-Release number of selected component (if applicable): Latest How reproducible: Internally Steps to Reproduce: 1. Minor update to 16.2.6 2. 3. Actual results: Users are no longer able to to create ports in shared/external networks. Expected results: No regression. Additional info:
It depends on order of how SQL returns records for the rbac. If the shared rbac entry is returned first then it works. If external rbac is returned first then tenants don't see the shared networks since there is GROUP BY clause in the SQL query - created by https://review.opendev.org/c/openstack/neutron-lib/+/884878/1/neutron_lib/db/model_query.py
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory (Updated Red Hat OpenStack Platform 16.2.6 container images), and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2024:0082
*** Bug 2307326 has been marked as a duplicate of this bug. ***