Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

is it possible to set the return value of `auth.role()` to something else?

Yes this is possible, but this should never be done. What are you trying to accomplish?

Not for myself, someone on another server asked a question where they seemed to define an RLS policy that had something like `auth.role() = 'taskmanager'` 😅 wanted to make sure that that was the issue

as in, their rules were faulty because auth.role() would never be equal to that value

Whatever you do, don't try creating a ACL with the auth functions, create your own table and deal with it that way