How to get app_metadata in RLS policy?

I've tried the following:

((auth.jwt() ->> 'app_metadata')::jsonb ->> 'active_team')::uuid

((auth.jwt() ->> 'app_metadata')::jsonb ->> 'active_team')::uuid

((auth.jwt() ->> 'app_metadata')::jsonb ->> 'active_team')::uuid

((auth.jwt() ->> 'app_metadata')::jsonb ->> 'active_team')::uuid

((current_setting('request.jwt.claims')::jsonb ->> 'app_metadata')::jsonb ->> 'active_team')::uuid

((current_setting('request.jwt.claims')::jsonb ->> 'app_metadata')::jsonb ->> 'active_team')::uuid

((current_setting('request.jwt.claims')::jsonb ->> 'app_metadata')::jsonb ->> 'active_team')::uuid

((current_setting('request.jwt.claims')::jsonb ->> 'app_metadata')::jsonb ->> 'active_team')::uuid

Nether seem to work. Is there an advised way to accomplish this?

garyaustin•12/3/22, 9:53 PM

When you use ->>->> that is calling for a text result. To move thru the json you use ->->
An example:
coalesce(nullif(current_setting('request.jwt.claims', true), '')::jsonb -> 'app_metadata' -> claim, null)coalesce(nullif(current_setting('request.jwt.claims', true), '')::jsonb -> 'app_metadata' -> claim, null)

KolbyOP•12/3/22, 10:16 PM

I see. ->-> did the trick. I'll read up more about these functions. Thanks for your help Gary

How to get app_metadata in RLS policy?

Similar Threads

Similar Threads

Similar Threads