角色、超级用户权限和不支持的操作
Supabase 会向所有部署的实例提供默认的 postgres 角色。不会提供超级用户权限,因为那样可能会对数据库执行破坏性操作。
🌐 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.
为了确保你不受影响,postgres 用户被授予了额外的权限,以允许它运行一些通常只限制超级用户的操作。
🌐 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.
不过,这确实意味着一些通常需要 superuser 权限的操作在 Supabase 上不可用。具体内容如下所示:
🌐 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 PROGRAMALTER USER ... WITH SUPERUSER