Roles and permissions

info

Lakebase Autoscaling is available in the following regions: us-east-1, us-east-2, eu-central-1, eu-west-1, eu-west-2, ap-south-1, ap-southeast-1, ap-southeast-2.

Lakebase Autoscaling is the latest version of Lakebase with autoscaling compute, scale-to-zero, branching, and instant restore. For feature comparison with Lakebase Provisioned, see choosing between versions.

Postgres roles control who can access your database and what actions they can perform. Before users can connect to your database, you must create Postgres roles for them and grant appropriate permissions to access data.

note

Postgres roles control database access (who can query data). For project permissions (who can manage infrastructure), see Project permissions.

Set up database access

• • Manage Postgres roles
  • Create OAuth and password-based Postgres roles for database access.
• • Manage permissions
  • Grant database permissions to Postgres roles using SQL GRANT commands.

Next steps

• Quickstart: Connect to your database
• Learn about authentication
• Tutorial: Grant project and database access to a new user