rembrembdocs

Access Control


Supabase provides granular access controls to manage permissions across your organizations and projects.

For each organization and project, a member can have one of the following roles:

Read-Only role is only available on the Team and Enterprise plans.

When you first create an account, a default organization is created for you and you'll be assigned as the Owner. Any organizations you create will assign you as Owner as well.

Manage organization members#

To invite others to collaborate, visit your organization's team settings to send an invite link to another user's email. The invite is valid for 24 hours. For project scoped roles, you may only assign a role to a single project for the user when sending the invite. You can assign roles to multiple projects after the user accepts the invite.

Invites sent from a SAML SSO account can only be accepted by another SAML SSO account from the same identity provider.

This is a security measure to prevent accidental invites to accounts not managed by your enterprise's identity provider.

Viewing organization members using the Management API#

You can also view organization members using the Management API:

1# Get your access token from https://supabase.com/dashboard/account/tokens2export SUPABASE_ACCESS_TOKEN="your-access-token"3export ORG_ID="your-organization-id"45# List organization members6curl "https://api.supabase.com/v1/organizations/$ORG_ID/members" \7  -H "Authorization: Bearer $SUPABASE_ACCESS_TOKEN"

Transferring ownership of an organization#

Each Supabase organization must have at least one owner. If your organization has other owners then you can relinquish ownership and leave the organization by clicking Leave team in your organization's team settings.

Otherwise, you'll need to invite a user as Owner, and they need to accept the invitation, or promote an existing organization member to Owner before you can leave the organization.

Organization scoped roles vs project scoped roles#

Project scoped roles are only available on the Team and Enterprise plans.

Each member in the organization can be assigned a role that is scoped either to the entire organization or to specific projects.

This allows for more granular control, ensuring that users only have visibility and access to the projects relevant to their role.

Organization permissions across roles#

The table below shows the actions each role can take on the resources belonging to the organization.

Resource

Action

Owner

Administrator

Developer

Read-Only1

Organization

Organization Management

Update

Delete

OpenAI Telemetry Configuration2

Update

Members

Organization Members

List

Owner

Add

Remove

Administrator

Add

Remove

Developer

Add

Remove

Owner (Project-Scoped)

Add

Remove

Administrator (Project-Scoped)

Add

Remove

Developer (Project-Scoped)

Add

Remove

Invite

Revoke

Resend

Accept3

Billing

Invoices

List

Billing Email

View

Update

Subscription

View

Update

Billing Address

View

Update

Tax Codes

View

Update

Payment Methods

View

Update

Usage

View

Integrations (Org Settings)

Authorize GitHub

-

Add GitHub Repositories

-

GitHub Connections

Create

Update

Delete

View

Vercel Connections

Create

Update

Delete

View

OAuth Apps

OAuth Apps

Create

Update

Delete

List

Audit Logs

View Audit logs

-

Legal Documents

SOC2 Type 2 Report

Download

Security Questionnaire

Download

Project permissions across roles#

The table below shows the actions each role can take on the resources belonging to the project.

Resource

Action

Owner

Admin

Developer

Read-Only45

Project

Project Management

Transfer

Create

Delete

Update (Name)

Pause

Restore

Restart

Custom Domains

View

Update

Data (Database)

View

Manage

Infrastructure

Read Replicas

List

Create

Delete

Add-ons

Update

Integrations

Authorize GitHub

-

Add GitHub Repositories

-

GitHub Connections

Create

Update

Delete

View

Vercel Connections

Create

Update

Delete

View

Database Configuration

Reset Password

-

Pooling Settings

View

Update

SSL Configuration

View

Update

Disk Size Configuration

View

Update

Network Restrictions

View

Create

Delete

Network Bans

View

Unban

API Configuration

API Keys

Read service key

Read anon key

JWT Secret

View

Generate new

API settings

View

Update

Auth Configuration

Auth Settings

View

Update

SMTP Settings

View

Update

Advanced Settings

View

Update

Storage Configuration

Upload Limit

View

Update

S3 Access Keys

View

Create

Delete

Edge Functions Configuration

Secrets

View

6

Create

Delete

SQL Editor

Queries

Create

Update

Delete

View

List

Run

7

Database

Scheduled Backups

View

Download

Restore

Physical backups (PITR)

View

Restore

Authentication

Users

Create

Delete

List

Send OTP

Send password recovery

Send magic link

Remove MFA factors

Providers

View

Update

Rate Limits

View

Update

Email Templates

View

Update

URL Configuration

View

Update

Hooks

View

Create

Delete

Storage

Buckets

Create

Update

Delete

View

List

Files

Create (Upload)

Update

Delete

List

Edge Functions

Edge Functions

Update

Delete

View

List

Reports

Custom Report

Create

Update

Delete

View

List

Logs & Analytics

Queries

Create

Update

Delete

View

List

Run

Branching

Production Branch

Read

Write

Development Branches

List

Create

Update

Delete

Footnotes#

  1. Available on the Team and Enterprise Plans.

  2. Sending anonymous data to OpenAI is opt in and can improve Studio AI Assistant's responses.

  3. Invites sent from a SSO account can only be accepted by another SSO account coming from the same identity provider. This is a security measure that prevents accidental invites to accounts not managed by your company's enterprise systems.

  4. Available on the Team and Enterprise Plans.

  5. Listed permissions are for the API and Dashboard.

  6. Read-Only role is able to access secrets.

  7. Limited to executing SELECT queries. SQL Query Snippets run by the Read-Only role are run against the database using the supabase_read_only_user. This role has the predefined Postgres role pg_read_all_data.