Preventing write access to Prod DB on Supabase Pro
🤷other
Hi,
I’m on the Pro plan with 3 separate projects: dev, staging, and prod. I have multiple developers who need Studio / GUI access, but I want to prevent any schema or data writes to the prod database (no SQL editor / table editor changes).
Since Pro doesn’t seem to support read-only roles or project-scoped permissions, what’s the recommended way to prevent accidental writes to Prod project.
Is the only option to isolate prod into a separate org with very limited access, or am I missing something?
I’m on the Pro plan with 3 separate projects: dev, staging, and prod. I have multiple developers who need Studio / GUI access, but I want to prevent any schema or data writes to the prod database (no SQL editor / table editor changes).
Since Pro doesn’t seem to support read-only roles or project-scoped permissions, what’s the recommended way to prevent accidental writes to Prod project.
Is the only option to isolate prod into a separate org with very limited access, or am I missing something?
