Transcript
Will fixing Supabase RLS break your app? Not if you add rules first. RLS decides who reads what. Turn it on with no rules, and your lists come back empty. Open the first finding. It explains the problem in plain words, with a fix.
This fix adds rules too: users get only their own profile. Notes still need work. To write every rule at once, open Generate policies. It doesn’t read your project, so start from Personal app and rename tables to match.
Each click sets who can do what, and the card shows you the Postgres policy. It removes your old rules, even the one that let anyone read everything. If it’s meant for everyone, set Anyone to Yes.
Copy the SQL and run it in the SQL Editor, on a test project first. Run the check again. Paste the new value. Nothing serious found. Signed out, you see nothing. Signed in, you see only your own rows.
Free, no sign-up. Link in the description.
Sources
Where the facts in this video come from. Everything shown on screen is a test project with made-up data.