mirror of
https://github.com/supabase/supabase.git
synced 2026-06-14 05:06:27 +08:00
17 lines
685 B
Plaintext
17 lines
685 B
Plaintext
---
|
|
id: 'roles'
|
|
title: 'Roles, superuser access and unsupported operations'
|
|
slug: 'roles'
|
|
---
|
|
|
|
Supabase provides the default `postgres` role to all instances deployed. Superuser access is not given as it allows destructive operations to be performed on the database.
|
|
|
|
To ensure you are not impacted by this, additional privileges are granted to the `postgres` user to allow it to run some operations that are normally restricted to superusers.
|
|
|
|
However, this does mean that some operations, that typically require `superuser` privileges, are not available on Supabase. These are documented below:
|
|
|
|
## Unsupported operations
|
|
|
|
- `COPY ... FROM PROGRAM`
|
|
- `ALTER USER ... WITH SUPERUSER`
|