fix: Reduce postgres user grants

[filipecabaco]

trafficstars

What kind of change does this PR introduce?

Reduces the permissions given to the postgres user to reduce error prone operations from users when interacting with the schema 'realtime'

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

1 Skipped Deployment

Name	Status	Preview	Comments	Updated (UTC)
realtime-demo	⬜️ Ignored (Inspect)	Visit Preview		Sep 24, 2024 3:26pm

[notion-workspace[bot]]

Reduce postgres grants in Realtime

[notion-workspace[bot]]

Reduce postgres grants in Realtime

[notion-workspace[bot]]

Reduce postgres grants in Realtime

[soedirgo]

@filipecabaco should we close this? We'll need to revisit the approach as a follow up to https://linear.app/supabase/project/restrict-auth-and-storage-schemas-from-user-modifications-5d2aa8402c9d

[filipecabaco]

yes let's close this one and tackle it in a follow up PR