PostgREST has an interesting approach to authentication that might give you some...

timwis on March 9, 2022 | parent | context | favorite | on: Postgres Auditing in 150 lines of SQL

PostgREST has an interesting approach to authentication that might give you some ideas:

Supabase is built on top of PostgREST, but I can’t say for sure it uses the same means of authentication (I think it has its own Auth layer).

oliverrice on March 9, 2022 [–]

Supabase passes all the JWT info to postgrest so it is still available in transaction local config