bypass (row level security) RLS in a postgres function

[zakaria-chahboun]

Hi!
I have a users table, with some RLS with auth.uid.() table!
I have a function that check if the email already exist or not - in my table 'users'.
So when i run it with rpc it's gives me always the same result return false, So how i can ran this rpc function and bypass the RLS in the client?

i know i can use service_role project API key with the server side - but my web app currently works in the client side only.

Thanks!

[soedirgo]

Hi Zakaria, you can use SECURITY DEFINER functions like here. If you are using the dashboard to create the function, you can enable the option from advanced settings.

[zakaria-chahboun]

@soedirgo Thanks!

[al-shseo]

I spent a lot of time on this
I didn't even know there was an option like that.

Thanks for solving it! thank you! 😊