I'm a little confused how stored procedures interact with row table policies. I have RLS on for my tables and a stored procedure that increments a row on one of the tables by one. Shouldn't the stored procedure fail?
There are no policies setup allowing inserts or updates and the function is not SECURITY DEFINER. Am I missing something?