SaimonOriginal post
Web Developer
Hi, I’m facing an issue with Realtime + Row Level Security in Appwrite.
- I set my collection permissions to:
User Create, Read, Update, Delete - Row Security is enabled.
- In this setup, Realtime data is not fetching.
- After reload I can see the update.👍
But if I change the collection permission to Any Read, then Realtime works fine (even with Row Security enabled).
This is a Next.js project. Repo for reference: https://github.com/nextSaimon/demo
Can someone please help me fix this so that Realtime works properly with User-level permissions + Row Security in Next.js?
Summary
Issue: Realtime not working with User permissions + Row Security in Appwrite for Next.js project.
Solution: Change collection permissions to `Any Read` instead of `User Create, Read, Update, Delete` to enable Realtime data fetching while keeping Row Security enabled.