Soheil Bakhshi has a recommendation for us:
However, managing RLS roles can be challenging if you have a large number of users or if your user base changes frequently. You need to manually assign each user account to one or more roles, which can be time-consuming and error-prone. Moreover, if a user changes their position or leaves the organisation, you must update their role membership accordingly.
This is where Security Groups become handy.
Soheil explains why and then gives us a step-by-step guide on what we can do to use security groups instead.