Skip to content

Privileges are not working correctly during migrating between projects due to default privileges being ALL for anon, authenticated #4862

@erenpal

Description

@erenpal

Describe the bug
Calling,
supabase db dump --db-url [CONNECTION_STRING] -f schema.sql
Gets Privileges of tables and columns as GRANTS but calling GRANT on a already existing privilege does nothing.
Due to default privileges being ALL for anon and authenticated, after tables are created they have ALL privileges.

To Reproduce
Follow steps in official docs. And check Privileges of columns and tables afterwards.
https://supabase.com/docs/guides/platform/migrating-within-supabase/backup-restore

Expected behavior
Privileges should be migrated correctly.

System information

  • Version of OS: Windows 10
  • Version of CLI: 2.75.0
  • Version of Docker: 4.56.0

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions