Would this be possible in RLS?
I have a form using the
anon key with RLS which lets users subscribe to updates. It checks if their email is already exists in the table using the SELECT operation but I only want to allow the user to check if their email exists in the table instead of allowing them to view every email stored. Is that possible to do?