I've got a table with an RLS policy on it:
Policies: POLICY "app_users_policy"
USING ((app_id = CURRENT_USER))
Is there a way I'm not aware of (e.g. via Pl/PGSQL) that would allow "migration" of data from one RLS owner to another
?
At the moment, the only option I can think of is for the external app to login as one user, cache the data and then
loginas the other user and re-save it.
Basically the background is that I want to give users the ability to self-service migrate their existing app profile
from"old" to "new" (the app being differentiated via RLS user on app_id)